Postgres Pro
Downloads
Home   >   mailing lists

Can we use sqlcode in functions of plpgsql - Mailing list pgsql-general

From tushar nehete
Subject Can we use sqlcode in functions of plpgsql
Date
Msg-id CANuBLQU7ts9rG8wCHZoT0xboUMvXqcmgMpuJxrgJOxutCe6bEQ@mail.gmail.com
Whole thread Raw
Responses Re: Can we use sqlcode in functions of plpgsql  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view
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?

pgsql-general by date:

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