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

2011-05-03 Thread Ross J. Reedstrom
On Tue, May 03, 2011 at 08:48:19AM +0200, Guillaume Lelarge wrote: > 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

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

2011-05-02 Thread Guillaume Lelarge
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

[ADMIN] simple question about using an empty string building a partial index

2011-05-02 Thread Tom Hartnett
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.