On 05/03/2011 05:52 AM, Tom Hartnett wrote: > can it be done? > > create index my_idx on my_table(col1) where col1=''; > > ERROR: invalid input syntax for integer: "" > > Seems simple enough but I don't know what the trick is. > col1 is an integer, not a string. And you cannot check for empty string in an integer column. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
