Received: from c014.sfo.cp.net (c014-h022.c014.sfo.cp.net [209.228.12.86]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1O52Zx57346 for ; Sat, 24 Feb 2001 00:02:35 -0500 (EST) (envelope-from ken@oldbs.com) Received: (cpmta 4964 invoked from network); 23 Feb 2001 21:02:33 -0800 Received: from unknown (HELO oldbs.com) (216.91.245.19) by smtp.oldbs.com (209.228.12.86) with SMTP; 23 Feb 2001 21:02:33 -0800 X-Sent: 24 Feb 2001 05:02:33 GMT Message-ID: <3A974086.EF665152@oldbs.com> Date: Sat, 24 Feb 2001 00:03:02 -0500 From: Ken Kline X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.16-22min_for_stan i586) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: greetings Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/379 X-Sequence-Number: 1580 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;