Thread: Good tutorial wanted...

Good tutorial wanted...

From
wim
Date:
  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
--------------------------------


Re: Good tutorial wanted...

From
Masse Jacques
Date:
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



Re: Good tutorial wanted...

From
"Josh Berkus"
Date:
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

Re: Good tutorial wanted...

From
"Robert J. Sanford, Jr."
Date:
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
>


Re: Good tutorial wanted...

From
"Brett W. McCoy"
Date:
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.


Re: Good tutorial wanted...

From
Joel Burton
Date:
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


Re: Good tutorial wanted...

From
"Robert J. Sanford, Jr."
Date:
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.
>
>