Is there a way to test for UNASSIGNED in pl/pgsql - Mailing list pgsql-hackers

From Hannu Krosing
Subject Is there a way to test for UNASSIGNED in pl/pgsql
Date
Msg-id 508EA21B.1070503@2ndQuadrant.com
Whole thread Raw
Responses Re: Is there a way to test for UNASSIGNED in pl/pgsql
List pgsql-hackers
Hi

Is there a way to test for a variable being unassigned in pl/pgsql ?

I'm writing an audit trigger where I'd like to save full before and
after images into audit log and I really do not like to do

IF TG_OP IN ('INSERT', 'UPDATE') ...

I'd like rather better if i could just write

IF NEW IS ASSIGNED THEN ...

or even use it straight

null_if_unnasigned(NEW)

overriding

coalesce(NEW, NULL)

for the same purpose would also be ok

---------------------
Hannu




pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: September 2012 commitfest
Next
From: Claudio Freire
Date:
Subject: Re: [PATCH] Prefetch index pages for B-Tree index scans