Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Underrated Features of PostgreSQL . Parent comment
CREATE UNIQUE INDEX index_name ON table_name (a, b) WHERE deleted_time IS NULL;
[1] http://www.postgresql.org/docs/9.1/static/indexes-partial.ht...
There are no comments on this comment yet.
CREATE UNIQUE INDEX index_name ON table_name (a, b) WHERE deleted_time IS NULL;
[1] http://www.postgresql.org/docs/9.1/static/indexes-partial.ht...