Re: simple question about using an empty string building a partial index

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