Re: [SQL] Looking for examples of S/P

2005-01-19 Thread John DeSoi
On Jan 19, 2005, at 4:03 AM, KÖPFERL Robert wrote: In order to learn SQL-Stored Procedure techniqes I'm looking for a series of examples. Where can I find examples of SQL and PL/pgSQL based stored procedures? Or any of you who wants to donate some? The pgEdit distribution includes an extensive exa

Re: [SQL] Looking for examples of S/P

2005-01-19 Thread RobertD . Stewart
I use this stored procedure to insert data into tables from my web page. I call it using select insert_masteraccount($1,$,2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13); CREATE OR REPLACE FUNCTION insert_masteraccount("varchar", "varchar", "varchar", "varchar", "varchar", "varchar", "varchar", "varchar

Re: [SQL] Looking for examples of S/P

2005-01-19 Thread Michael Fuhr
On Wed, Jan 19, 2005 at 10:03:13AM +0100, KÖPFERL Robert wrote: > In order to learn SQL-Stored Procedure techniqes I'm looking for a series of > examples. > Where can I find examples of SQL and PL/pgSQL based stored procedures? The General Bits column would be one place: http://www.varlena.com/v