Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL FUNCTION return type on INSERT - Mailing list pgsql-sql

From Edward Grabczewski
Subject Re: SQL FUNCTION return type on INSERT
Date
Msg-id 9s0tnd$1tbd$1@news.tht.net
Whole thread Raw
In response to SQL FUNCTION return type on INSERT  ("Edward Grabczewski" <edward.grabczewski@btinternet.com>)
List pgsql-sql
Tree view 
I've just looked at the new online 7.2 documentation and found that all
functions must end in some kind of select.
How about this then?

CREATE FUNCTION foo(varchar)
RETURN unknown
AS '     INSERT INTO footable VALUES ($1);     SELECT null; '
LANGUAGE 'sql';

"Edward Grabczewski" <edward.grabczewski@btinternet.com> wrote in message
news:9s0n0p$1saj$1@news.tht.net...
> What value should I RETURN for a SQL FUNCTION that contains an INSERT
> statement?
>
> --
> Eddy Grabczewski
> edward.grabczewski@btinternet.com
>
>
>

pgsql-sql by date:

Previous
From: "Edward Grabczewski"
Date:
Subject: Re: PL/pgSQL syntax for strings
Next
From: Tom Lane
Date:
Subject: Re: Strange Problem As Type Casting