Re: Correct Insert SQL syntax?

--- On Thu, 9/4/08, Ruben Gouveia <rubes7202(at)gmail(dot)com> wrote:

> From: Ruben Gouveia <rubes7202(at)gmail(dot)com>
> Subject: [SQL] Correct Insert SQL syntax?
> To: "pgsql-sql" <pgsql-sql(at)postgresql(dot)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?