Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL equivalent of the Oracale 'unique' qualifier - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: PostgreSQL equivalent of the Oracale 'unique' qualifier
Date
Msg-id 20061120201754.GG13555@alvh.no-ip.org
Whole thread Raw
In response to PostgreSQL equivalent of the Oracale 'unique' qualifier  ("Wm.A.Stafford" <stafford@marine.rutgers.edu>)
Responses Re: PostgreSQL equivalent of the Oracale 'unique' qualifier  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Wm.A.Stafford wrote:
> I hope the subject says it all.  I'm porting an Oracle-centric
> application to PostgreSQL and the Oracle sql is full of the 'unique'
> qualifier.  I'm assuming PostgreSQL does not support 'unique' since
> don't see a 'unique' anywhere in the PostgreSQL docs.  Is there a
> substitute or a technique to get the same result?

You gotta be kidding.  Of course Postgres supports UNIQUE.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: PostgreSQL equivalent of the Oracale 'unique'
Next
From: Bricklen Anderson
Date:
Subject: Re: PostgreSQL equivalent of the Oracale 'unique' qualifier