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