From: Michal Taborsky <M.Taborsky@sh.cvut.cz>
To: pgsql-sql@postgresql.org
Subject: Concatenating does not work properly
Date: Wed, 09 Apr 2003 16:14:41 +0200
Message-ID: <b719sp$24ki$1@news.hub.org> (raw)
Hello,
I am facing a problem I cannot really explain to myself. I have a table
with personal data which has columns surname, firstname, secondname,
title and I want to do a simple select like this:
SELECT (surname || ', ' || firstname || ' ' || secondname) as fullname
FROM person
For some rows (from what I recognised it is with rows, which have the
title column empty) it works, for some it returns empty string:
akcent=# SELECT (surname || ', ' || firstname || ' ' || secondname) as
fullname, title_pre, surname, firstname, secondname FROM person;
fullname | title_pre | surname | firstname | secondname
-----------------------+-----------+----------+-----------+------------
| Ing. | Taborsky | Michal |
| Ing. | Barta | David |
Novak, Josef | | Novak | Josef |
Saroch, Adrian Walter | | Saroch | Adrian | Walter
(4 rows)
Is that a bug or am I missing something ?
Thanks,
Michal
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: M.Taborsky@sh.cvut.cz
Subject: Re: Concatenating does not work properly
In-Reply-To: <b719sp$24ki$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox