Обсуждение: plpgsql problem

Поиск
Список
Период
Сортировка

plpgsql problem

От
tomek@lotnisko.pasjo.net.pl (Tomasz Chwajo³)
Дата:
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

От
Anand Raman
Дата:
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