On Wed, Dec 23, 2009 at 1:44 AM, Craig Ringer <cr...@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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
