Re: assign null value to a field in plpgsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Monarchi" <david(dot)e(dot)monarchi(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: assign null value to a field in plpgsql
Date: 2007-06-01 18:22:45
Message-ID: 17435.1180722165@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"David Monarchi" <david(dot)e(dot)monarchi(at)gmail(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Brian Hurt 2007-06-01 18:31:48 How do I insert a record into a table?
Previous Message David Monarchi 2007-06-01 18:05:40 assign null value to a field in plpgsql