From: Ian Lance Taylor <ian@airs.com>
To: Ken Kline <ken@oldbs.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: greetings
Date: 23 Feb 2001 22:25:43 -0800
Message-ID: <siae7c1tso.fsf@daffy.airs.com> (raw)
References: <3A974086.EF665152@oldbs.com>
Ken Kline <ken@oldbs.com> writes:
> I have just joined the list a few days ago and am trying quite hard
> to come up to speed with pgsql but i find documentaion frustratiing.
> I think maybe it;s just a matter of finding things that are of the
> correct
> scope. I've been an Oracle developer for over 6 years so often I
> know what it is I want to do but something is just a little different.
> If there are others on the list that learned in Oracle then pgsql
> please tell me what you think are the best resources.
>
> Recently I did a google search on the key words "postgresql cursor loop"
>
> the example below is all I could come up with but it doesn't seem
> to work is this for an older version or am I just overlooking
> something simple?
>
> thanks
>
> Ken
>
> DECLARE emp_cursor CURSOR FOR
> SELECT Salary, Title, Start, Stop
> FROM Employee;
> OPEN emp_cursor;
> loop:
> FETCH emp_cursor INTO :salary, :start, :stop;
> if no-data returned then goto finished;
> find position in linked list to insert this information;
> goto loop;
> finished:
> CLOSE emp_cursor;
PL/pgSQL does not support cursors. It also does not support goto.
You can write the above as something like (untested):
FOR emprec IN SELECT Salary, Title, Start, Stop FROM Employee LOOP
IF no-data returned then EXIT;
END LOOP;
I have a patch adding cursors to PL/pgSQL. You can find it at
http://www.airs.com/ian/pgsql-cursor.html
This patch will not be in 7.1, but it may be in 7.2.
However, it will not help you with the lack of goto. You shouldn't
really use goto for a simple program like your example. But perhaps
you are doing something more complex in your real code.
Ian
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: ian@airs.com, ken@oldbs.com
Subject: Re: greetings
In-Reply-To: <siae7c1tso.fsf@daffy.airs.com>
References: <3A974086.EF665152@oldbs.com> <siae7c1tso.fsf@daffy.airs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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