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@j-davis.com>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgresql" <pgsql-general@postgresql.org>
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
