Can we use sqlcode in functions of plpgsql

From: tushar nehete <tpnehete(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Can we use sqlcode in functions of plpgsql
Date: 2011-10-07 10:40:21
Message-ID: CANuBLQU7ts9rG8wCHZoT0xboUMvXqcmgMpuJxrgJOxutCe6bEQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
For backward compatibility and some other reasons we want to use
SQLCODE in our functions of PLPGSQL.
But in Postgres Server 9.0 it gives error for SQLCODE.
Is there any way to use SQLCODE in functions of PLPGSQL at the place of
SQLSTATE?
Also what is the datatype of SQLSTATE?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vincent de Phily 2011-10-07 10:54:04 Re: Never-idle autovacuum, and does (auto)vacuuming fill the OS cache ?
Previous Message Frank Lanitz 2011-10-07 09:26:46 Standby server witching into master role after import failure