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
On Sat, Dec 11, 2004 at 01:54:35PM -0600, Bruno Wolff III wrote:
>
> Empty strings and NULL values aren't the same thing. You probably either
> want to store empty strings or use coalesce to change NULL to an empty
> string before using concatenation, as a NULL concatenated with anything
> results
On Sat, Dec 11, 2004 at 03:33:07 +0100,
Stefan de Konink <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a table with some empty colums, if I try to concat my colums to
> eachother something strange happens. Rather empty column B produces
> virtually no output using the || in the select query. But
Hi,
I have a table with some empty colums, if I try to concat my colums to
eachother something strange happens. Rather empty column B produces
virtually no output using the || in the select query. But the half filed
colum A does give the desired output.
midvliet=# select snr, achternaam||', '||
