thankz :-)
On 4/10/05, Bruce Momjian <pgman@candle.pha.pa.us> wrote:
> Sibtay Abbas wrote:
> > Hello all
> >
> > Can we check whether a cursor is OPEN or not in plpgsql.
> > Like in oracle you can check a CURSOR'S state with <CURSOR_VAR>%ISOPEN
> >
> No, but we do have a TODO item:
>
> o Allow pooled connections to list all open WITH HOLD cursors
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania 19073
>
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
