--- On Thu, 9/4/08, Ruben Gouveia <[EMAIL PROTECTED]> wrote:
> From: Ruben Gouveia <[EMAIL PROTECTED]>
> Subject: [SQL] Correct Insert SQL syntax?
> To: "pgsql-sql" <pgsql-sql@postgresql.org>
> Date: Thursday, September 4, 2008, 10:16 PM
> Will this syntax work:
>
> fcn_stats are all in the same schema
>
> CREATE OR REPLACE FUNCTION insert_stats(p_date date)
> RETURNS void AS $$
>
> BEGIN
> insert into stats (
> date,
> stats1,
> stats2
> ) (select
> p_date,
>
> fcn_stats1(p_date,'basic'),
>
> fcn_stats2(p_date,'basic',0)
> from dual
> );
> END;
> $$ LANGUAGE 'plpgsql';
Dual is a table create for you or is the generic table of oracle?
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
