- Mailing list pgsql-general

From Daniel Schuchardt
Subject
Date
Msg-id 200310010957.h919vSQ13857@mailgate5.cinetic.de
Whole thread Raw
Responses Re:
Re:
List pgsql-general
Hi @ all,

I think thats a bug:

SELECT '#' || '#'

will work but

SELECT '#' || CAST(NULL AS VARCHAR)

will return only empty rows.
My Query looks like this : SELECT field1 || field2 FROM ...
If field2 ISNULL then everything is null. CAST does not help.

thanks for your help

Daniel
______________________________________________________________________________
Die Besten ihrer Klasse! WEB.DE FreeMail (1,7) und WEB.DE Club (1,9) -
bei der Stiftung Warentest - ein Doppelsieg! http://f.web.de/?mc=021184


pgsql-general by date:

Previous
From: Kris Jurka
Date:
Subject: Re: mod_auth_pgsql 2.0.1 don't close the backend connection
Next
From: Richard Huxton
Date:
Subject: Re: