Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Concatenation containing a "null" term
- From: Michael Fuhr <mike(at)fuhr(dot)org>
- To: Pierre Thibaudeau <pierdeux(at)gmail(dot)com>
- Cc: pgsql-novice(at)postgresql(dot)org
- Subject: Re: Concatenation containing a "null" term
- Date: Sun, 28 May 2006 15:33:37 -0600
On Sun, May 28, 2006 at 05:17:12PM -0400, Pierre Thibaudeau wrote: > 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 -- Michael Fuhr
- Follow-Ups:
- Re: Concatenation containing a "null" term
- From: Pierre Thibaudeau
- Re: Concatenation containing a "null" term
- References:
- Concatenation containing a "null" term
- From: Pierre Thibaudeau
- Concatenation containing a "null" term
- Prev by Date: Concatenation containing a "null" term
- Next by Date: Re: Concatenation containing a "null" term
- Previous by thread: Concatenation containing a "null" term
- Next by thread: Re: Concatenation containing a "null" term
- Indexes: