underscore split to alias

Поиск
Список
Период
Сортировка
От Erik Rijkers
Тема underscore split to alias
Дата
Msg-id 8470cc81b8a6c305c942e34aaeede3b1.squirrel@webmail.xs4all.nl
обсуждение исходный текст
Ответы Re: underscore split to alias  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I am not sure this is a bug, but I was surprised by the following behaviour
in HEAD and 8.4.4 (instances built today, 2010.05.14):

Invalid (?) values like 123_456 are split before the underscore and interpreted as
123 as "456":


$ psql -p 6591 -d testdb -c "select 123_456, current_setting('server_version')"_456 | current_setting
------+----------------- 123 | 9.0beta1
(1 row)


$ psql -p 6584 -d testdb -c "select 123_456, current_setting('server_version')"_456 | current_setting
------+----------------- 123 | 8.4.4
(1 row)


Older versions (8.3 thru 7.4) all give an error:


$ psql -p 6583 -d testdb -c "select 123_456, current_setting('server_version')"
ERROR:  syntax error at or near "_456"
LINE 1: select 123_456, current_setting('server_version')                 ^

The error given by the older servers seems justified.  I assume
this is a bug and not a deliberate change?


thanks,


Erik Rijkers






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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Parameter oddness; was HS/SR Assert server crash
Следующее
От: Tom Lane
Дата:
Сообщение: Re: underscore split to alias