"Corin" <i...@netskin.com> writes: > CREATE INDEX fanobjects_amazon_product_id_index > ON fanobjects > USING btree > (amazon_product_id) > WHERE NOT amazon_product_id IS NULL;
Try it like WHERE amazon_product_id IS NOT NULL; > I'd consider this a bug as "NOT x IS NULL" is the same as "x IS NOT NULL". We don't expend an infinite number of cycles on rewriting different query formulations into each other, and that's one of the ones we don't handle ... regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs