simple question about using an empty string building a partial index

From: Tom Hartnett <tdhartnett(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: simple question about using an empty string building a partial index
Date: 2011-05-03 03:52:04
Message-ID: BANLkTimkN8c4WVtNGQY0nbY_aPdR-yiEfg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2011-05-03 06:48:19 Re: simple question about using an empty string building a partial index
Previous Message Raghavendra 2011-05-02 17:32:51 Re: OID for pg_get_functiondef