Re: [SQL] Return from stored procedures

2000-11-10 Thread Kovacs Zoltan Sandor
> 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 kn

[SQL] Return from stored procedures

2000-11-10 Thread Graham Vickrage
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