Concatenating not working properly
От | Michal Taborsky |
---|---|
Тема | Concatenating not working properly |
Дата | |
Msg-id | 3E94343A.1060108@sh.cvut.cz обсуждение исходный текст |
Ответы |
Re: Concatenating not working properly
Re: Concatenating not working properly |
Список | 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
В списке pgsql-sql по дате отправления: