| From: | Michal Taborsky <M(dot)Taborsky(at)sh(dot)cvut(dot)cz> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Concatenating not working properly |
| Date: | 2003-04-09 14:54:50 |
| Message-ID: | 3E94343A.1060108@sh.cvut.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-04-09 15:12:48 | Re: question about visibilty while updating multiple rows . |
| Previous Message | Michal Taborsky | 2003-04-09 14:14:41 | Concatenating does not work properly |