Re: Inserting a needed record before a select - Mailing list pgsql-general

At 12:27 PM 04/14/2003 -0600, scott.marlowe wrote:

>Crap, sorry, you're right.  You'll need to use a rule.  Rules are simpler
>than triggers / functions.  They're described in the programmer's guide,
>section 13 for 7.3.2.

Problem is RULEs don't seem to have the sophistication I need (boolean
logic...search for a record and if it doesn't exists, insert it, then
re-SELECT on the same table)

Take care,
Jay