<no subject>

From: "Daniel Schuchardt" <daniel_schuchardt(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: <no subject>
Date: 2003-10-01 09:57:29
Message-ID: 200310010957.h919vSQ13857@mailgate5.cinetic.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-10-01 10:07:43 Re: <no subject>
Previous Message Kris Jurka 2003-10-01 08:28:35 Re: mod_auth_pgsql 2.0.1 don't close the backend connection