PL/SQL & unset custom variable

From: Gordon Ross <gr306(at)ucs(dot)cam(dot)ac(dot)uk>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: PL/SQL & unset custom variable
Date: 2009-09-02 13:28:52
Message-ID: C6C431A4.9E89%gr306@staff-ad.csi.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

(I'm using Postgres 8.3)

I have a trigger that references a custom variable. Most of the time this
custom variable is set, and I have no problems.

However, in certain corner cases the custom variable is not set and the
trigger fails.

Is there a way to either test if the custom variable is set, or to specify a
global default for the custom variable ?

Thanks,

GTG

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Massa, Harald Armin 2009-09-02 13:47:53 Re: creating array of integer[] out of query - how?
Previous Message Himanshu Gupta 2009-09-02 13:19:51 Re: how to use multiple schema's