Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Troy
Subject Re: PostgreSQL equivalent of the Oracale 'unique' qualifier
Date
Msg-id Pine.LNX.4.33.0611201305590.19262-100000@denzel.in
Whole thread Raw
In response to PostgreSQL equivalent of the Oracale 'unique' qualifier  ("Wm.A.Stafford" <stafford@marine.rutgers.edu>)
List pgsql-general
Tree view 

On Mon, 20 Nov 2006, 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?
>
> Thanks,
> -=bill stafford
>

Would "distinct" do it for you?

RT

--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
rtroy@ScienceTools.com, http://ScienceTools.com/

pgsql-general by date:

Previous
From: "Wm.A.Stafford"
Date:
Subject: PostgreSQL equivalent of the Oracale 'unique' qualifier
Next
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL equivalent of the Oracale 'unique' qualifier