Re: assign null value to a field in plpgsql - Mailing list pgsql-novice

From Tom Lane
Subject Re: assign null value to a field in plpgsql
Date
Msg-id 17435.1180722165@sss.pgh.pa.us
Whole thread Raw
In response to assign null value to a field in plpgsql  ("David Monarchi" <david.e.monarchi@gmail.com>)
List pgsql-novice
"David Monarchi" <david.e.monarchi@gmail.com> writes:
> I want to go through a series of checks to see if I should set a field to
> null in the adServerLoadRow.  I will not know in advance which fields I will
> need to check nor their data types.
> ...
> I'm constrained to use plpgsql,

You've been given an impossible set of constraints, because plpgsql is a
statically-typed language.  Use another PL.

            regards, tom lane

pgsql-novice by date:

Previous
From: "David Monarchi"
Date:
Subject: assign null value to a field in plpgsql
Next
From: Brian Hurt
Date:
Subject: How do I insert a record into a table?