Re: PostgreSQL equivalent of the Oracale 'unique' qualifier

From: gonzales(at)linuxlouis(dot)net
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 20:24:13
Message-ID: Pine.LNX.4.64.0611201523080.7578@mx1.linuxlouis.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Are you talking about a SQL statement qualifier, where you may be
referring to "distinct"

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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

--
Louis Gonzales
louis(dot)gonzales(at)linuxlouis(dot)net
http://www.linuxlouis.net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wm.A.Stafford 2006-11-20 20:27:39 More on unique vs distinct
Previous Message Dann Corbit 2006-11-20 20:24:03 Re: PostgreSQL equivalent of the Oracale 'unique' qualifier