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

From Joshua D. Drake
Subject Re: PostgreSQL equivalent of the Oracale 'unique'
Date
Msg-id 1164053739.16182.87.camel@localhost.localdomain
Whole thread Raw
In response to PostgreSQL equivalent of the Oracale 'unique' qualifier  ("Wm.A.Stafford" <stafford@marine.rutgers.edu>)
List pgsql-general
On Mon, 2006-11-20 at 15:13 -0500, 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?

Distinct?

Joshua D. Drake


>
> Thanks,
> -=bill stafford
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate




pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_get_serial_sequence is inconsistent
Next
From: Alvaro Herrera
Date:
Subject: Re: PostgreSQL equivalent of the Oracale 'unique' qualifier