Re: Insert NULL for ''

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jonathan Bartlett <johnnyb(at)eskimo(dot)com>
Cc: Daniel Gehrke <dgehrke(at)neusta(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: Insert NULL for ''
Date: 2003-06-13 14:59:46
Message-ID: 828.1055516386@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jonathan Bartlett <johnnyb(at)eskimo(dot)com> writes:
> Could you instead have a function around it?
> into foo (bar) values (myfunction(''))
> Where myfunction maps '' to null.

That would be an easy solution (one of many) if we could make any
changes in the SQL being emitted by the application, but I think
Daniel is saying that he doesn't want to touch the application at all.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-06-13 15:00:30 Re: Choosing Between PL/PGSQL or C/C++ for Triggers/Store
Previous Message Oleg Bartunov 2003-06-13 14:58:19 Re: tsearch - v2 new dict