On Wed, Dec 23, 2009 at 1:44 AM, Craig Ringer
<craig@postnewspapers.com.au> wrote:
> SELECT COALESCE( t_number::text, t:string::text, t_date::text, t_boolean::text) AS value;
Your invocation of COALESCE is incorrect -- it is n-ary, but it
returns its first non-NULL argument. Instead, try:
SELECT COALESCE(t_number::text, '') || COALESCE(t_string::text, '') || COALESCE(t_date::text, '') ||
COALESCE(t_boolean::text,'') ||
...
rls
--
:wq