Re: Howto have a unique restraint on UPPER (textfield)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: Joshua Tolley <eggyknap(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Howto have a unique restraint on UPPER (textfield)
Date: 2010-01-31 21:07:46
Message-ID: 16294.1264972066@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Andreas <maps(dot)on(at)gmx(dot)net> writes:
> So I had the missconception that UNIQUE (...) within CREATE TABLE (...)
> was actually just an shorter way to define a unique index which it is not.

Well, it is that --- it just doesn't provide access to all the features
that CREATE INDEX does.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dave Clements 2010-02-01 00:50:22 Fwd: Help required on query performance
Previous Message Andreas 2010-01-31 20:48:28 Re: Howto have a unique restraint on UPPER (textfield)