Re: Triggers

From: Richard Huxton <dev(at)archonet(dot)com>
To: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Triggers
Date: 2004-11-29 09:48:48
Message-ID: 41AAF080.8020607@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jamie Deppeler wrote:
> Hi,
>
> Just doing some testing at the moment and trying to make a trigger that
> consists of a insert statement which as a result of an sql querty!

Look into using EXECUTE - it accepts a string expression and executes
it. Don't forget to use the quote_xxx() functions to quote identifiers etc.

--
Richard Huxton
Archonet Ltd

In response to

  • Triggers at 2004-11-29 03:16:51 from Jamie Deppeler

Browse pgsql-general by date

  From Date Subject
Next Message Gevik Babakhani 2004-11-29 09:51:28 Re: tool for postgresql
Previous Message Richard Huxton 2004-11-29 09:46:38 Re: Table and Field Schemas