| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Looking for examples of S/P |
| Date: | 2005-01-19 14:19:31 |
| Message-ID: | 22D8C258-6A25-11D9-9B29-000A95B03262@pgedit.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Fradkin | 2005-01-19 15:23:01 | Conversion ideas (Views/procedures) |
| Previous Message | Karsten Hilbert | 2005-01-19 13:18:47 | Re: Returning a bool on DELETE in a proc. |