Search Postgresql Archives

Can we use sqlcode in functions of plpgsql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general General <pgsql-general@xxxxxxxxxxxxxx>
Subject: Can we use sqlcode in functions of plpgsql
From: tushar nehete <tpnehete@xxxxxxxxx>
Date: Fri, 7 Oct 2011 16:10:21 +0530

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?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Can we use sqlcode in functions of plpgsql
  - From: Pavel Stehule

Prev by Date: Standby server witching into master role after import failure
Next by Date: Re: Never-idle autovacuum, and does (auto)vacuuming fill the OS cache ?
Previous by thread: Standby server witching into master role after import failure
Next by thread: Re: Can we use sqlcode in functions of plpgsql
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux