Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: coalesce for null AND empty strings
- From: Alban Hertroys <alban(at)magproductions(dot)nl>
- To: Ferdinand Gassauer <gassauer(at)kde(dot)org>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: coalesce for null AND empty strings
- Date: Fri, 30 Mar 2007 10:41:45 +0200
Ferdinand Gassauer wrote: > Hi! > > it would be great to have a coalesce2 function which treats empty strings as > null values. I think COALESCE(NULLIF(value1, ''), value2) does what you want. You could wrap that in a new function coalesce2 if you like. -- Alban Hertroys alban(at)magproductions(dot)nl magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede // Integrate Your World //
- References:
- coalesce for null AND empty strings
- From: Ferdinand Gassauer
- coalesce for null AND empty strings
- Prev by Date: Re: coalesce for null AND empty strings
- Next by Date: PANIC: unexpected hash relation size
- Previous by thread: Re: coalesce for null AND empty strings
- Next by thread: Some encoding trouble via libpq
- Indexes: