Re: Question about inserts

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Stijn Vanroye <s(dot)vanroye(at)farcourier(dot)com>
Cc: mike <mike(at)redtux1(dot)uklinux(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Question about inserts
Date: 2004-04-23 13:56:58
Message-ID: 20040423135658.GB6182@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 23, 2004 at 13:07:43 +0200,
Stijn Vanroye <s(dot)vanroye(at)farcourier(dot)com> wrote:
> Maybe you can do something with this function:
>
> [quote from the postgres docs]
> 9.12.2. COALESCE
> COALESCE(value [, ...])

That's the inverse of what he would want if he used that approach. NULLIF
is what turns things into NULLs.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2004-04-23 14:02:57 Re: Question about inserts
Previous Message Stijn Vanroye 2004-04-23 13:54:52 Re: Question about inserts