Thread: Return from stored procedures

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';

Cheers

Graham

> 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