Thanks Jeff
I'm going through a learning curve. I don't need to add possible
instability.
Thanks again.
Bob
----- Original Message -----
From: "Jeff Davis" <pgsql@xxxxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "Postgresql" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Wednesday, November 29, 2006 4:41 PM
Subject: Re: [GENERAL] Version 8.1
On Wed, 2006-11-29 at 15:31 -0800, Bob Pawley wrote:
I may as well bite the bullet.
If you're going to migrate to 8.1, you might consider migrating to 8.2
since it's almost released. That depends on your timeline though; 8.1 is
a safer bet if you need stability now.
Is this the syntax to use ???
CREATE OR REPLACE FUNCTION p_id.loopnumber()
RETURNS "trigger" AS $$
Update p_id.loop_sequence
Set function_ = library.devices.designation
From p_id.loops
where p_id.loop_sequence.monitor = p_id.devices.devices_id
and p_id.devices.device_number = library.devices.device_number ;
RETURN NULL;
END;
$$
LANGUAGE 'plpgsql' ;
CREATE TRIGGER loopnumbering AFTER INSERT ON p_id.loops
FOR EACH ROW EXECUTE PROCEDURE p_id.loopnumber();
I think you need library.devices and p_id.devices in the fromlist. Also,
why is p_id.loops in the fromlist if it's not a part of the WHERE?
Regards,
Jeff Davis
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
