On Wed, Dec 23, 2009 at 1:44 AM, Craig Ringer
<craig(at)postnewspapers(dot)com(dot)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