Thread: Good tutorial wanted...
Hello, I need to write some functions in my PostgresDB... Does anyone know a good tutorial on the Internet. I need to have some explanation on the use of variables, the while-loop and how to implement functions in Postgres... -- Kind regards, Wim De Hul Belgacom Belbone -------------------------------- Mail : wdh@belbone.be Mobile : +32 479 952004 Ripe : WDH25-RIPE Registered Linux User: #260015 --------------------------------
I found some examples in http://www.commandprompt.com/ppbook/ see chap. 11 ___________________________________________ Jacques Massé Tel. 33 (0)5 57 89 08 11 - Fax 33 (0)5 57 89 08 01
Wim, > I need to write some functions in my PostgresDB... > Does anyone know a good tutorial on the Internet. > I need to have some explanation on the use of variables, > the while-loop and how to implement functions in Postgres... > Check out TechDocs: http://techdocs.postgresql.org/ Particularly, Roberto Mello's improved PL/pgSQL documentation and function library are useful. -Josh
just out of curiosity... why isn't there a big-honkin' link on the postgres site that says "lots of additional, really really useful information can be found at http://techdocs.postgresql.org/"? lots of questions could be answered if there was a link that was obvious... rjsjr > -----Original Message----- > From: pgsql-novice-owner@postgresql.org > [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Josh Berkus > Sent: Friday, March 08, 2002 10:28 AM > To: wim; pgsql-novice@postgresql.org > Subject: Re: [NOVICE] Good tutorial wanted... > > > Wim, > > > I need to write some functions in my PostgresDB... > > Does anyone know a good tutorial on the Internet. > > I need to have some explanation on the use of variables, > > the while-loop and how to implement functions in Postgres... > > > > Check out TechDocs: > http://techdocs.postgresql.org/ > > Particularly, Roberto Mello's improved PL/pgSQL documentation and > function library are useful. > > -Josh > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
On Fri, 8 Mar 2002, Robert J. Sanford, Jr. wrote: > just out of curiosity... > > why isn't there a big-honkin' link on the postgres site that says "lots of > additional, really really useful information can be found at > http://techdocs.postgresql.org/"? > > lots of questions could be answered if there was a link that was obvious... You mean aside from ones like this: The second in a series of free PostgreSQL Computer Based Training tutorials based on Macromedia Flash has been released. It teaches the introductory concepts of Referential Integrity in PostgreSQL and is available at http://techdocs.postgresql.org/college/002_referentialintegrity. or this Justin Clift has created a new documentation section containing information that doesn't really belong in an FAQ and doesn't really belong in "the Manual" at http://techdocs.postgresql.org. which are right on the front page? -- Brett http://www.chapelperilous.net/ ------------------------------------------------------------------------ BOFH excuse #281: The co-locator cannot verify the frame-relay gateway to the ISDN server.
On Fri, 8 Mar 2002, Brett W. McCoy wrote: > On Fri, 8 Mar 2002, Robert J. Sanford, Jr. wrote: > > > just out of curiosity... > > > > why isn't there a big-honkin' link on the postgres site that says "lots of > > additional, really really useful information can be found at > > http://techdocs.postgresql.org/"? > > > > lots of questions could be answered if there was a link that was obvious... > > You mean aside from ones like this: > > The second in a series of free PostgreSQL Computer Based Training > tutorials based on Macromedia Flash has been released. It teaches the > introductory concepts of Referential Integrity in PostgreSQL and is > available at > http://techdocs.postgresql.org/college/002_referentialintegrity. > > or this > > Justin Clift has created a new documentation section containing > information that doesn't really belong in an FAQ and doesn't really > belong in "the Manual" at http://techdocs.postgresql.org. > > which are right on the front page? I would say, yeah, aside from these. I think techdocs should be a link on the left-hand side, on the same level of importance as the others. -- Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton Independent Knowledge Management Consultant
yes, i do mean aside from that. those like nice little one-off's and if i'm not really interested in a flash CBT i might not go there. techdocs has a LOT of information on there but if you just click on those little links or think that the only thing there is the CBT and ignore the links then you miss out. i beat my head against the wall for about three days trying to get postgresql to build on my osx box when i was digging through the archives and discovered that techdocs has a rather nice section on installation as well as links to pre-built binaries that aren't directly downloadable in the official download dirs. in the "user's lounge" the link to techdocs is referred to as "non-faq documentation" which says almost nothing. it obviously isn't the faq becuase it says so and it isn't the official docs because there's another section for those. so what is it? techdocs is a very useful section of the website and the rest of the site does it a disservice by not giving it the press that it deserves. make it stand out so that when somebody new comes along they know that there is a lot more info out there that can be useful. rjsjr > -----Original Message----- > From: Brett W. McCoy [mailto:bmccoy@chapelperilous.net] > Sent: Friday, March 08, 2002 3:02 PM > To: Robert J. Sanford, Jr. > Cc: pgsql-novice@postgresql.org > Subject: Re: [NOVICE] Good tutorial wanted... > > > On Fri, 8 Mar 2002, Robert J. Sanford, Jr. wrote: > > > just out of curiosity... > > > > why isn't there a big-honkin' link on the postgres site that > says "lots of > > additional, really really useful information can be found at > > http://techdocs.postgresql.org/"? > > > > lots of questions could be answered if there was a link that > was obvious... > > You mean aside from ones like this: > > The second in a series of free PostgreSQL Computer Based Training > tutorials based on Macromedia Flash has been released. It teaches the > introductory concepts of Referential Integrity in PostgreSQL and is > available at > http://techdocs.postgresql.org/college/002_referentialintegrity. > > or this > > Justin Clift has created a new documentation section containing > information that doesn't really belong in an FAQ and doesn't really > belong in "the Manual" at http://techdocs.postgresql.org. > > which are right on the front page? > > -- Brett > http://www.chapelperilous.net/ > ------------------------------------------------------------------------ > BOFH excuse #281: > > The co-locator cannot verify the frame-relay gateway to the ISDN server. > >