Re: coalesce and nvl question

Hi

Thanks, I should have thought of that myself!

Simon
On Wed, 2004-06-23 at 19:43, Bruno Wolff III wrote:
> On Wed, Jun 23, 2004 at 19:10:05 +0100,
>   Simon Windsor <simon.windsor@cornfield.org.uk> wrote:
> > Hi
> >
> > I understand that null and '' are different, and MySQL and Oracle
> > functions are confusing, but my question was not about replacing NULL
> > but replacing Empty strings. These are handled in MySQL/Oracle by the
> > same functions that do NULL checks.
> >
> > Is there a standard function in Postgres that replaces Empty strings, as
> > against a NULL value.
>
> Something like the following may suit your purposes:
> coallesce(nullif(inputstring,''), 'replacement value')
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
--
Simon Windsor
Email: simon.windsor@cornfield.org.uk
Tel: 01454 617689
Mob: 07960 321599


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Mailscanner thanks transtec Computers for their support.