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