Re: PostgreSQL equivalent of the Oracale 'unique' qualifier

From: Richard Troy <rtroy(at)ScienceTools(dot)com>
To: "Wm(dot)A(dot)Stafford" <stafford(at)marine(dot)rutgers(dot)edu>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL equivalent of the Oracale 'unique' qualifier
Date: 2006-11-20 21:06:25
Message-ID: Pine.LNX.4.33.0611201305590.19262-100000@denzel.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)ScienceTools(dot)com, http://ScienceTools.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2006-11-20 21:28:17 Re: pg_get_serial_sequence is inconsistent
Previous Message Shelby Cain 2006-11-20 20:29:00 Re: PostgreSQL equivalent of the Oracale 'unique' qualifier