thankz :-) On 4/10/05, Bruce Momjian <pgman@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxx | (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
