 | | From: | KÖPFERL_Robert | | Subject: | Looking for examples of S/P | | Date: | Wed, 19 Jan 2005 10:03:13 +0100 |
|
|
 | 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 your friend
|
|
| | From: | Michael Fuhr | | Subject: | Re: Looking for examples of S/P | | Date: | Wed, 19 Jan 2005 02:48:09 -0700 |
|
|
| 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/varlena/GeneralBits/
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
|
|
| | From: | John DeSoi | | Subject: | Re: Looking for examples of S/P | | Date: | Wed, 19 Jan 2005 09:19:31 -0500 |
|
|
|
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 example for importing and
analyzing web server logs using only SQL and PL/pgSQL. Look in the
pgEdit/Examples/web folder after installation.
http://pgedit.com/download
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
|
|
