Skip site navigation (1) Skip section navigation (2)

Re: Concatenation containing a "null" term

From: "Pierre Thibaudeau" <pierdeux(at)gmail(dot)com>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Concatenation containing a "null" term
Date: 2006-05-29 02:43:50
Message-ID: 74b035bb0605281943l44a1ec7bx43b740dd672faed9@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
>
> > Is there a way of having the null-strings terms of the concatenation
> > operator be considered as empty strings instead?
>
> Use COALESCE.  Some people create a custom concatenation operator
> that automatically does so.
>
>
> http://www.postgresql.org/docs/8.1/interactive/functions-conditional.html#AEN12639
> http://www.postgresql.org/docs/8.1/interactive/sql-createoperator.html
>

Simple, swift and bang on target! Thank you!

In response to

pgsql-novice by date

Next:From: Russell DavieDate: 2006-05-29 21:41:53
Subject: changing user id
Previous:From: Michael FuhrDate: 2006-05-28 21:33:37
Subject: Re: Concatenation containing a "null" term

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group