Thread: What is the Best Way to Learn PL/pgSQL?

hi all,

what is the best way to learn PL/pgSQL?  I'm having
difficulty finding tutorials, let alone onoes that
make both the whys and hows simple to absorb for a
newbie.

should i search for PL/SQL tutorials or books and then
apply what I learn over to PL/pgSQL?

tia...



__________________________________________
Yahoo! DSL – Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com

Yes, me too.  I tried to find some good tutorials.

I did not find. I printed from the mother Postgres
documentation.

I guess chapter 37 if i am correct.

It does deal with good information. However, there not
many good examples provided for that chapter.

I did not find any tutorial that deal with lots of
examples. I think in Postgres learning from examples
is the best way.

In Bruce momijan's book also not much of pl/pgsql is
dealt.

I request the community/experts to prepare a nice
tutorials for people like me and many.

Thank you.


--- operationsengineer1@yahoo.com wrote:

> hi all,
>
> what is the best way to learn PL/pgSQL?  I'm having
> difficulty finding tutorials, let alone onoes that
> make both the whys and hows simple to absorb for a
> newbie.
>
> should i search for PL/SQL tutorials or books and
> then
> apply what I learn over to PL/pgSQL?
>
> tia...
>
>
>
> __________________________________________
> Yahoo! DSL – Something to write home about.
> Just $16.99/mo. or less.
> dsl.yahoo.com
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will
> ignore your desire to
>        choose an index scan if your joining column's
> datatypes do not
>        match
>




__________________________________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs

operationsengineer1@yahoo.com wrote:
> hi all,
>
> what is the best way to learn PL/pgSQL?  I'm having
> difficulty finding tutorials, let alone onoes that
> make both the whys and hows simple to absorb for a
> newbie.
>
> should i search for PL/SQL tutorials or books and then
> apply what I learn over to PL/pgSQL?
>
> tia...

Hi,

I got started with pl/sql on oracle using their docs, which
are quite readable. Yes, it's not the same as pl/pgsql but
to get the concepts, it might be worth reading.

http://www.csee.umbc.edu/help/oracle8/server.815/a67842/toc.htm

Best regards,
Marcus

Hello
Besides the tip for oracle take a look at the some books on postgresql:

1)PHP and PostgreSQL Advanced Web Programming by  Ewald Geschwinde, Hans- Juergen Schoenig
Older version of postgresql <8.0 but prety nice examples ( from personal experiece verry usefull book on many aspects of postgresql)

2)PostgreSQL By Korry Douglas, Susan Douglas
thinks also older version of postgresql < 8.0 (don't know much about it)

With kind regards

--
Met vriendelijke groet
Manjusri Schuit