Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Rules with sequence columns
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Ray Madigan <ray(at)madigans(dot)org>
- Cc: Pgsql-Sql <pgsql-sql(at)postgresql(dot)org>
- Subject: Re: Rules with sequence columns
- Date: Wed, 28 Mar 2007 12:17:05 -0400
Ray Madigan <ray(at)madigans(dot)org> writes: > Does anyone have any suggestion? Use a trigger to propagate the data to the other table. You can't make this work reliably with a rule, because rules are macros and hence inherently subject to double-evaluation problems when dealing with volatile functions. regards, tom lane
- References:
- Rules with sequence columns
- From: Ray Madigan
- Rules with sequence columns
- Prev by Date: Rules with sequence columns
- Next by Date: Re: union with count?
- Previous by thread: Rules with sequence columns
- Next by thread: How too select different views using a IF/THEN/ELSE procedure ?
- Indexes: