From: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
---|---|
To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | No Return?? |
Date: | 2008-04-13 20:07:26 |
Message-ID: | 00c401c89da1$fee1b740$6401a8c0@owner |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm getting a little frustrated with this problem.
Can anyone tell me what is wrong with the following code.
I have tested the portions separately and they all work.
When I try it as a whole I get the message "control reached end of trigger
procedure without RETURN."
Any help greatly appreciated.
Bob
Declare
pumpnumber integer;
Begin
Select count(*) Into pumpnumber From p_id.devices, p_id.processes
Where device_number = '11'
and p_id.devices.fluid_id = p_id.processes.fluid_id
and p_id.processes.ip_op_equipment = 'op';
If pumpnumber = 1 then
Update p_id.devices
Set number = '#1'
From p_id.processes
Where p_id.devices.number is null
and p_id.devices.device_number = '11'
and p_id.devices.fluid_id = p_id.processes.fluid_id
and p_id.processes.ip_op_equipment = 'op' ;
Else If pumpnumber = 2 Then
Update p_id.devices
Set number = '#2'
From p_id.processes
Where p_id.devices.number is null
and p_id.devices.device_number = '11'
and p_id.devices.fluid_id = p_id.processes.fluid_id
and p_id.processes.ip_op_equipment = 'op' ;
End If;
RETURN NULL;
End If;
END;
I have tried 'Return New' and 'Return Result' without luck, and if I leave
off either of the two 'End If ' statements the procedure returns an error.
B
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2008-04-13 20:18:31 | Re: No Return?? |
Previous Message | Stephan Szabo | 2008-04-13 16:43:33 | Re: SQL injection, php and queueing multiple statement |