Re: Preventing duplicate records according to several fields - Mailing list pgsql-general

On Sep 21, 2005, at 10:34 AM, CSN wrote:

> id, title, yield, directions
>
> and would like to prevent duplicate records from being
> added (i.e. according to the title, yield, and
> directions fields).

<snip />

> - Create a unique index across the title, yield, and
> directions fields.

This scenario is exactly what the UNIQUE contraint is for.

Michael Glaesemann
grzm myrealbox com