Postgres Pro
Downloads
Home   >   mailing lists

Thread: SQL return value...

SQL return value...

From
"Cristian Prieto"
Date:

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?

Re: SQL return value...

From
Michael Glaesemann
Date:
On Oct 20, 2005, at 3:24 , 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?
>
>

Anything you want :). If you don't want to return anything, you can
use RETURNS VOID

Michael Glaesemann
grzm myrealbox com

Re: [GENERAL] SQL return value...

From
Richard Huxton
Date:
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