Postgres Pro
Downloads
Home   >   mailing lists

simple question about using an empty string building a partial index - Mailing list pgsql-admin

From Tom Hartnett
Subject simple question about using an empty string building a partial index
Date
Msg-id BANLkTimkN8c4WVtNGQY0nbY_aPdR-yiEfg@mail.gmail.com
Whole thread Raw
Responses Re: simple question about using an empty string building a partial index
List pgsql-admin
Tree view
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.

pgsql-admin by date:

Previous
From: Raghavendra
Date:
Subject: Re: OID for pg_get_functiondef
Next
From: Guillaume Lelarge
Date:
Subject: Re: simple question about using an empty string building a partial index