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
end if; else end if; END IF; Return NEW; END; ' LANGUAGE 'plpgsql' VOLATILE; -Original Message- From: KÖPFERL Robert [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 19, 2005 4:03 AM To: pgsql-sql@postgresql.org Subject: [SQL] Looking for examples of S/

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

[SQL] Looking for examples of S/P

2005-01-19 Thread KÖPFERL Robert
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? ---(end of broadcast)--- TIP 8: explain analyze is y