Re: PostgreSQL equivalent of the Oracale 'unique' qualifier

From: Shelby Cain <alyandon(at)yahoo(dot)com>
To: stafford(at)marine(dot)rutgers(dot)edu, pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL equivalent of the Oracale 'unique' qualifier
Date: 2006-11-20 20:29:00
Message-ID: 20061120202901.59355.qmail@web55404.mail.re4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm guessing that is an Oracle-ism for the sql DISTINCT keyword.

Regards,

Shelby Cain

----- Original Message ----
From: Wm.A.Stafford <stafford(at)marine(dot)rutgers(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Sent: Monday, November 20, 2006 2:13:13 PM
Subject: [GENERAL] PostgreSQL equivalent of the Oracale 'unique' qualifier

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


____________________________________________________________________________________
Sponsored Link

Don't quit your job - take classes online
www.Classesusa.com

Browse pgsql-general by date

  From Date Subject
Next Message Richard Troy 2006-11-20 21:06:25 Re: PostgreSQL equivalent of the Oracale 'unique' qualifier
Previous Message Wm.A.Stafford 2006-11-20 20:27:39 More on unique vs distinct