pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPL/PGSQL Cook Book
6+ messages / 5 participants
[nested] [flat]
* PL/PGSQL Cook Book
@ 2001-02-09 12:02 mark proctor <m.proctor@bigfoot.com>
2001-02-12 22:11 ` Re: PL/PGSQL Cook Book Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 6+ messages in thread
From: mark proctor @ 2001-02-09 12:02 UTC (permalink / raw)
To: pgsql-sql
I've just spent the last day or two trying to get to grips with plpgsql and can't believe how abysmal the documetentation and examples are.
I've been trawling through the mailist lists and I notice there was talk back in 1999 abouta PLPGSQL Cook Book - did anything come of this?
If no one is maintaining something like this and people think its a good idea I think we should have another crack at it.
I'd be happy to maintain something like this and put it up on the web, although I'm only a newbie and would rely upon user contribution.
Here are some possible sections to help get people thinking. Even if you don't know the answer send me the questions and I'll add them to the list.
How can I create Tree structures?
Are recursive functions supported?
Whats are the advanteds disadvantes of the different scipting langues PL/PGSQL, PL/Perl, PL/Tcl?
How do variable scopes work in PL/PGSQL?
Can I output variables from a function to the command line for debugging purposes?
How to debug PL/PGSQL?
Various examples for each of the statements
Anyway lets discuss this, a lot could be done just from piecing together relavent tips from this mailing list.
ie there are some good posts on tree structures, which if I'm willing to piece together if people think this project is worth while.
Regards
Mark
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PL/PGSQL Cook Book
2001-02-09 12:02 PL/PGSQL Cook Book mark proctor <m.proctor@bigfoot.com>
@ 2001-02-12 22:11 ` Peter Eisentraut <peter_e@gmx.net>
2001-02-12 22:06 ` Re: PL/PGSQL Cook Book Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Peter Eisentraut @ 2001-02-12 22:11 UTC (permalink / raw)
To: mark proctor <m.proctor@bigfoot.com>; +Cc: pgsql-sql
mark proctor writes:
> I've been trawling through the mailist lists and I notice there was
> talk back in 1999 abouta PLPGSQL Cook Book - did anything come of
> this? If no one is maintaining something like this and people think
> its a good idea I think we should have another crack at it. I'd be
> happy to maintain something like this and put it up on the web,
> although I'm only a newbie and would rely upon user contribution.
Start writing, and send it to pgsql-docs@postgresql.org. It doesn't have
to be a great work of literature; incremental work is just fine.
> How can I create Tree structures?
> Are recursive functions supported?
> Whats are the advanteds disadvantes of the different scipting langues PL/PGSQL, PL/Perl, PL/Tcl?
> How do variable scopes work in PL/PGSQL?
> Can I output variables from a function to the command line for debugging purposes?
> How to debug PL/PGSQL?
> Various examples for each of the statements
All valid questions.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PL/PGSQL Cook Book
2001-02-09 12:02 PL/PGSQL Cook Book mark proctor <m.proctor@bigfoot.com>
2001-02-12 22:11 ` Re: PL/PGSQL Cook Book Peter Eisentraut <peter_e@gmx.net>
@ 2001-02-12 22:06 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2001-02-12 22:06 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: mark proctor <m.proctor@bigfoot.com>; pgsql-sql
Even a PL/PgSQL FAQ would be good.
> mark proctor writes:
>
> > I've been trawling through the mailist lists and I notice there was
> > talk back in 1999 abouta PLPGSQL Cook Book - did anything come of
> > this? If no one is maintaining something like this and people think
> > its a good idea I think we should have another crack at it. I'd be
> > happy to maintain something like this and put it up on the web,
> > although I'm only a newbie and would rely upon user contribution.
>
> Start writing, and send it to pgsql-docs@postgresql.org. It doesn't have
> to be a great work of literature; incremental work is just fine.
>
> > How can I create Tree structures?
> > Are recursive functions supported?
> > Whats are the advanteds disadvantes of the different scipting langues PL/PGSQL, PL/Perl, PL/Tcl?
> > How do variable scopes work in PL/PGSQL?
> > Can I output variables from a function to the command line for debugging purposes?
> > How to debug PL/PGSQL?
> > Various examples for each of the statements
>
> All valid questions.
>
> --
> Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
>
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 6+ messages in thread
* PL/PGSQL Cook Book
@ 2001-02-09 20:23 plpgsql@polar-digital.com
2001-02-10 00:24 ` Re: PL/PGSQL Cook Book ender <kthangavelu@earthlink.net>
0 siblings, 1 reply; 6+ messages in thread
From: plpgsql@polar-digital.com @ 2001-02-09 20:23 UTC (permalink / raw)
To: pgsql-sql
I've just spent the last day or two trying to get to grips with plpgsql and can't believe how abysmal the documetentation and examples are.
I've been trawling through the mailist lists and I notice there was talk back in 1999 abouta PLPGSQL Cook Book - did anything come of this?
If no one is maintaining something like this and people think its a good idea I think we should have another crack at it.
I'd be happy to maintain something like this and put it up on the web, although I'm only a newbie and would rely upon user contribution.
Here are some possible sections to help get people thinking. Even if you don't know the answer send me the questions and I'll add them to the list.
How can I create Tree structures?
Are recursive functions supported?
Whats are the advanteds disadvantes of the different scipting langues PL/PGSQL, PL/Perl, PL/Tcl?
How do variable scopes work in PL/PGSQL?
Can I output variables from a function to the command line for debugging purposes?
How to debug PL/PGSQL?
Various examples for each of the statements
Anyway lets discuss this, a lot could be done just from piecing together relavent tips from this mailing list.
ie there are some good posts on tree structures, which if I'm willing to piece together if people think this project is worth while.
Regards
Mark
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PL/PGSQL Cook Book
2001-02-09 20:23 PL/PGSQL Cook Book plpgsql@polar-digital.com
@ 2001-02-10 00:24 ` ender <kthangavelu@earthlink.net>
2001-02-09 23:30 ` Re: Re: PL/PGSQL Cook Book Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: ender @ 2001-02-10 00:24 UTC (permalink / raw)
To: pgsql-sql
On Friday 09 February 2001 12:23, plpgsql@polar-digital.com wrote:
> I've just spent the last day or two trying to get to grips with plpgsql and
> can't believe how abysmal the documetentation and examples are. I've been
> trawling through the mailist lists and I notice there was talk back in 1999
> abouta PLPGSQL Cook Book - did anything come of this?
a good body of open source plpgsql code is in the openacs distribution at
openacs.org.
i agree that plpgsql is poorly documented, the only way i found to figure out
its capabilities were to scour the mailing lists, the openacs code, and the
plpgsql implementation source. any attempt to better this documentation would
IMO, be a worthwhile effort.
hth
kapil
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Re: PL/PGSQL Cook Book
2001-02-09 20:23 PL/PGSQL Cook Book plpgsql@polar-digital.com
2001-02-10 00:24 ` Re: PL/PGSQL Cook Book ender <kthangavelu@earthlink.net>
@ 2001-02-09 23:30 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2001-02-09 23:30 UTC (permalink / raw)
To: ender <kthangavelu@earthlink.net>; +Cc: m.proctor@bigfoot.com; pgsql-sql
[ Charset ISO-8859-1 unsupported, converting... ]
> On Friday 09 February 2001 12:23, plpgsql@polar-digital.com wrote:
> > I've just spent the last day or two trying to get to grips with plpgsql and
> > can't believe how abysmal the documetentation and examples are. I've been
> > trawling through the mailist lists and I notice there was talk back in 1999
> > abouta PLPGSQL Cook Book - did anything come of this?
>
> a good body of open source plpgsql code is in the openacs distribution at
> openacs.org.
>
> i agree that plpgsql is poorly documented, the only way i found to figure out
> its capabilities were to scour the mailing lists, the openacs code, and the
> plpgsql implementation source. any attempt to better this documentation would
> IMO, be a worthwhile effort.
I have added PL/PgSQL to the open 7.1 docs list. Let's see if someone
takes a stab at it.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2001-02-12 22:11 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-09 12:02 PL/PGSQL Cook Book mark proctor <m.proctor@bigfoot.com>
2001-02-12 22:11 ` Peter Eisentraut <peter_e@gmx.net>
2001-02-12 22:06 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-02-09 20:23 PL/PGSQL Cook Book plpgsql@polar-digital.com
2001-02-10 00:24 ` ender <kthangavelu@earthlink.net>
2001-02-09 23:30 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox