I'm guessing that is an Oracle-ism for the sql DISTINCT keyword. Regards, Shelby Cain ----- Original Message ---- From: Wm.A.Stafford <stafford@xxxxxxxxxxxxxxxxxx> To: pgsql-general@xxxxxxxxxxxxxx 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