Checking cursor's state in plpgsql

From: Sibtay Abbas <sibtay(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Checking cursor's state in plpgsql
Date: 2005-04-04 16:50:16
Message-ID: bd6a355105040409501c81db26@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

After navigating the documentation i was not able to find an
equivalent in plpgsql.

Do we have an alternative to this in plpgsql?

Thankz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chandra Sekhar Surapaneni 2005-04-04 16:59:32 Regarding niladic functions
Previous Message Pavel Stehule 2005-04-04 16:39:33 Re: How to query pgsql from a BASH script ?