Thread: plpgsql problem

plpgsql problem

From
tomek@lotnisko.pasjo.net.pl (Tomasz Chwajo³)
Date:
How can I check if the command has been done properly?
For example:
1)
INSERT INTO...
IF ?record_has_been_added? THEN ...

2)
SELECT ...
IF ?record_has_been_found? THEN ...

Tomek

Re: plpgsql problem

From
Anand Raman
Date:
the second case can be determined by using FOUND  which is set to either
true or false when a select statement returns a row.. Not sure about the
first..
Anand
On Fri, Apr 13, 2001 at 10:12:02PM +0200, Tomasz Chwajo³ wrote:
>How can I check if the command has been done properly?
>For example:
>1)
>INSERT INTO...
>IF ?record_has_been_added? THEN ...
>
>2)
>SELECT ...
>IF ?record_has_been_found? THEN ...
>
>Tomek
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org