Re: [GENERAL] A trigger question

2006-12-25 Thread Chansup Byun
On 12/20/06, Bruno Wolff III <[EMAIL PROTECTED]> wrote: On Mon, Dec 18, 2006 at 22:18:43 -0500, Chansup Byun <[EMAIL PROTECTED]> wrote: > Hi, > > I'm trying to set up a trigger to prevent any duplicate entries into > my table. But I couldn't figure out how to make my trigger work. Couldn't you

Re: [GENERAL] A trigger question

2006-12-20 Thread Bruno Wolff III
On Mon, Dec 18, 2006 at 22:18:43 -0500, Chansup Byun <[EMAIL PROTECTED]> wrote: > Hi, > > I'm trying to set up a trigger to prevent any duplicate entries into > my table. But I couldn't figure out how to make my trigger work. Couldn't you use a unique constraint to do this? ---

Re: [GENERAL] A trigger question

2006-12-19 Thread Jonathan Hedstrom
Chansup Byun wrote: > Hi, > > I'm trying to set up a trigger to prevent any duplicate entries into > my table. But I couldn't figure out how to make my trigger work. > > I have a PostgreSQL 8.1.5 installation. > I created the following table: > > CREATE TABLE attendance ( > attendance_id se

[GENERAL] A trigger question

2006-12-19 Thread Chansup Byun
Hi, I'm trying to set up a trigger to prevent any duplicate entries into my table. But I couldn't figure out how to make my trigger work. I have a PostgreSQL 8.1.5 installation. I created the following table: CREATE TABLE attendance ( attendance_id serial, service_date timestam