Re: Return from stored procedures

From: Kovacs Zoltan Sandor <tip(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
To: Graham Vickrage <graham(at)digitalplanit(dot)com>
Cc: postgresql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Return from stored procedures
Date: 2000-11-10 11:08:50
Message-ID: Pine.LNX.4.05.10011101207310.21241-100000@pc10.radnoti-szeged.sulinet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Sandis Jerics 2000-11-10 11:55:18 sorting the text values as integers
Previous Message KuroiNeko 2000-11-10 10:00:50 Re: Re: Requests for Development