Bug #604: string join problem

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #604: string join problem
Date: 2002-02-26 13:50:07
Message-ID: 20020226135007.96D9747583B@postgresql.org
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-bugs

Erol Ozcan (erol(at)infotron(dot)com(dot)tr) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
string join problem

Long Description
I have a major problem with string joining in sql query in Postgresql 7.1.3. It is always return null string if any of column has null value.
I attached some example code sources to explain the problem.

Sample Code
CREATE TABLE phone
(
phn_id INT NOT NULL PRIMARY KEY,
phn_country INT NULL,
phn_area INT NULL,
phn_number INT NULL,
phn_ext INT NULL
);
INSERT INTO phone VALUES( 30, 90, 216, 4921002, NULL );
SELECT '+'|| phn_country||'-'||phn_area||'-'||phn_number FROM phone WHERE phn_id=30;
?column?
-----------------
+90-216-4921002
(1 row)

SELECT '+'||phn_country||'-'||phn_area||'-'||phn_number||' ext:'||phn_ext FROM phone WHERE phn_id=30;
?column?
----------

(1 row)

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-02-26 15:28:47 Re: Bug #603: time() problems with PostgreSQL 7.2
Previous Message pgsql-bugs 2002-02-26 13:43:38 Bug #603: time() problems with PostgreSQL 7.2