Re: SQL return value...

From: Richard Huxton <dev(at)archonet(dot)com>
To: Cristian Prieto <cristian(at)clickdiario(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL return value...
Date: 2005-10-20 07:34:23
Message-ID: 4357487F.9070609@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Cristian Prieto wrote:
> This is maybe a really newbie question, but, when I have an SQL function
> like that:
>
> $$
> Insert into mytable (id, name) values ($1, $2);
> $$
>
> What return value suppose to return?

Either return "void" or return "boolean" and add a "SELECT true;"
statement to the end of your function.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-10-20 07:38:22 Re: From oracle to postgresql...
Previous Message Richard Huxton 2005-10-20 07:30:54 Re: server , client encoding issue

Browse pgsql-novice by date

  From Date Subject
Next Message Gan Uesli Starling 2005-10-20 20:00:04 Array elem as foreign key?
Previous Message Michael Glaesemann 2005-10-19 22:33:30 Re: SQL return value...