Re: Return from stored procedures - Mailing list pgsql-sql

From Kovacs Zoltan Sandor
Subject Re: Return from stored procedures
Date
Msg-id Pine.LNX.4.05.10011101207310.21241-100000@pc10.radnoti-szeged.sulinet.hu
Whole thread Raw
In response to Return from stored procedures  ("Graham Vickrage" <graham@digitalplanit.com>)
List pgsql-sql
> Probably a very simple question, but how do you define a function that
> returns the sucess of an insert or update in a function i.e.
> 
> CREATE FUNCTION foo ( varchar, int8 ) RETURNS bool
>     AS 'UPDATE table WHERE something'
>     LANGUAGE 'sql';
With SQL functions you can't (as far as I know). Try PLPGSQL ones instead,
you can use the keyword 'found'. See the documentation for details.

Zoltan 



pgsql-sql by date:

Previous
From: KuroiNeko
Date:
Subject: Re: Re: Requests for Development
Next
From: Christophe Boyanique
Date:
Subject: SELECT FROM t1 WHERE id IN (SELECT id FROM t2 UNION SELECT id FROM t3)