Correct Insert SQL syntax? - Mailing list pgsql-sql

From Ruben Gouveia
Subject Correct Insert SQL syntax?
Date
Msg-id 51e507b0809041516s23978e0btb1e8540d68971656@mail.gmail.com
Whole thread Raw
Responses Re: Correct Insert SQL syntax?  ("Yura Gal" <yuragal@gmail.com>)
Re: Correct Insert SQL syntax?  (Lennin Caro <lennin.caro@yahoo.com>)
List pgsql-sql
<div dir="ltr">Will this syntax work:<br /><br />fcn_stats are all in the same schema<br /><br />CREATE OR REPLACE
FUNCTIONinsert_stats(p_date date)<br />RETURNS void AS $$<br />          <br />          BEGIN<br />                   
insertinto stats (<br />                             date,<br />                            stats1,<br
/>                           stats2<br />                    ) (select<br />                          p_date,<br
/>                         fcn_stats1(p_date,'basic'),<br />                           fcn_stats2(p_date,'basic',0)<br
/>                         from dual<br />                     );<br />END;<br />$$ LANGUAGE 'plpgsql';<br
/>                   <br /></div> 

pgsql-sql by date:

Previous
From: "Ruben Gouveia"
Date:
Subject: Re: Dynamic SQL Syntax help please
Next
From: "Yura Gal"
Date:
Subject: Re: Correct Insert SQL syntax?