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

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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/oracle...a67842/toc.htm

Best regards,
Marcus

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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

On 12/4/05, Marcus Engene <mengpg@engene.se> wrote:
>
> 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/oracle...a67842/toc.htm
>
> Best regards,
> Marcus
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>