Change in behavior of string concat operator

Поиск
Список
Период
Сортировка
От Benjamin Krajmalnik
Тема Change in behavior of string concat operator
Дата
Msg-id F4E6A2751A2823418A21D4A160B689882B8AAF@fletch.stackdump.local
обсуждение исходный текст
Ответы Re: Change in behavior of string concat operator  ("Milen A. Radev" <milen@radev.net>)
Список pgsql-admin
I just migrated from 8.1 to 8.3, running on FreeBSD 7.0 amd64.
Running 8.3.5
 
I have a query concatenating 3 columns to create a hash.
userid is a numeric(38,0) field, accountno is an integer, and requestdate is a date.
 
Under 8.1,  Select userid || accountno || requestdate::date as newcolumn from table executed ok.
Under 8.3, it gives the following error:
 
operator does not exist: numeric || integer
 
Typecasting the first two columns to varchar resolved the problem.
 
Select userid::varchar || accountno::varchar || requestdate::date as newcolumn from table
At the very least, the documentation should be updated to reflect the new behavior, although I believe this is a bug.
 

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Michael Nacos"
Дата:
Сообщение: load-testing postgresql servers with Tsung
Следующее
От: "Milen A. Radev"
Дата:
Сообщение: Re: Change in behavior of string concat operator