Where is IFNULL? - Mailing list pgsql-general

From Sascha Ziemann
Subject Where is IFNULL?
Date
Msg-id m3u2luekqr.fsf@intra.do.khs-ag.de
Whole thread Raw
Responses Re: [GENERAL] Where is IFNULL?
List pgsql-general
Hi,

the user manual describes the function IFNULL on page 38, but when I
try to use it I get the following error:

  users=> select ifnull (NULL, 'nix');
  ERROR:  No such function 'ifnull' with the specified attributes

What do I have to do to get the function?

Or does anybody know a simple way to concatenate strings, which can be
NULL?

Sascha

pgsql-general by date:

Previous
From: Thomas Drillich
Date:
Subject: no primary key on self designed type
Next
From: Stuart Rison
Date:
Subject: Re: [SQL] Fw: Whats happen here?