Skip site navigation (1) Skip section navigation (2)

Re: concat fails 'sometimes' on empty colums in select

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-bugs(at)postgresql(dot)org, Stefan de Konink <skinkie(at)xs4all(dot)nl>
Subject: Re: concat fails 'sometimes' on empty colums in select
Date: 2004-12-12 20:17:47
Message-ID: 200412121217.47142.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Stefan,

> To simplify this operation you could create an operator that does
> the coalesce for you.  This has come up recently; search the list
> archives for examples.

Actually, it's on General Bits:
http://www.varlena.com/varlena/GeneralBits/84.php

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-bugs by date

Next:From: Bryan RobertsDate: 2004-12-13 00:28:18
Subject: Win 32 'could not attach to proper memory at fixed address'
Previous:From: slawekDate: 2004-12-12 17:03:54
Subject: Error in pg_dump and pg_dumpall

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group