Skip site navigation (1) Skip section navigation (2)

Re: PL/pgSQL CURSOR support

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Jan Wieck <JanWieck(at)yahoo(dot)com>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>, PostgreSQL HACKERS <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PL/pgSQL CURSOR support
Date: 2001-05-31 17:16:15
Message-ID: 200105311716.f4VHGFS28125@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Jan has approved the following patch that allows both FOR and IS for
PL/PgSQL cursors.

> >     DECLARE  <name>  CURSOR IS <select_stmt> is the Oracle PL/SQL
> >     syntax. Since PL/pgSQL was written from the  start  with  one
> >     eye  on  portability  from/to  Oracle, I'd like to stick with
> >     that.
> > 
> >     It's relatively simple to just substitute  all  PLpgSQL  (and
> >     other case combos) occurences by something else, then replace
> >     the gram.y and scan.l files with whatever you want and voila,
> >     you come up with another procedural language as compatible as
> >     possible to your formerly preferred  database.  There  is  no
> >     reason  other  than  that  we'll  have  more  PL  handlers to
> >     support,  why  we  shouldn't  have  two  or  three  different
> >     procedural  SQL dialects. All can coexist and only those used
> >     in your DB schema will get loaded.
> 
> OK, how about this patch that allows both FOR and IS.  Seems like a
> good idea, and we can document FOR.
> 
> Also, I don't see any documentation on the new plpgsql cursor support.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-hackers by date

Next:From: Lamar OwenDate: 2001-05-31 17:18:32
Subject: Re: Non-ASCII locales (was:Re: Imperfect solutions)
Previous:From: Bruce MomjianDate: 2001-05-31 17:00:03
Subject: Re: Access statistics

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group