On Nov 23, 2007, at 17:35 , James B. Byrne wrote:
Why is this desire not better satisfied by an index rather than a key?
What's your distinction between an index and a key? For what it's
worth, both UNIQUE and PRIMARY KEY constrain a column (or set of
columns) to be unique, or a key in the logical sense. Uniqueness is
implemented in terms of btree indexes in PostgreSQL. It seems to me
you're conflating logical (key) and physical (index) concepts here.
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
