Re: [SQL] BEFORE UPDATE Triggers

Chris Anderson wrote: PostgreSQL Version: 7.2.3 Procedural Language: PL/pgSQL I have a table which contains a field for the user who last modified the record. Whenever a row in this table is updated, I want to have an UPDATE trigger do the following things: 1) Ensure the UPDATE query supplied

[SQL] Getting the return type right for SETOF

Hi folks, I'm playing with SETOF on functions. But I can't get the return type correct. What have I missed? A cast? CREATE OR REPLACE FUNCTION elementGet (text) RETURNS SETOF element_type AS ' select 1, \'test\', \'F\' \'A\', FALSE, FALSE ' LANGUAGE

Re: [SQL] Getting the return type right for SETOF

On Sat, 30 Aug 2003, Dan Langille wrote: Hi folks, I'm playing with SETOF on functions. But I can't get the return type correct. What have I missed? A cast? CREATE OR REPLACE FUNCTION elementGet (text) RETURNS SETOF element_type AS ' select 1, \'test\', \'F\'

Re: [SQL] BEFORE UPDATE Triggers

Jan Wieck [EMAIL PROTECTED] writes: Unfortunately, you're right. There is no way do distinguish in a trigger or rule if a value in the new row did result from the UPDATE query or from target list expansion with OLD values. It would not be terribly hard to examine the original query during