Re: Inserting a needed record before a select

From: "Jay O'Connor" <joconnor(at)cybermesa(dot)com>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Inserting a needed record before a select
Date: 2003-04-14 19:09:11
Message-ID: 3.0.1.32.20030414130911.0085ae90@cybermesa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-04-14 19:16:42 Re: Batch replication ordering (was Re: [GENERAL] 32/64-bit
Previous Message Ed L. 2003-04-14 19:01:37 Re: Batch replication ordering (was Re: [GENERAL] 32/64-bit