underscore split to alias

From: "Erik Rijkers" <er(at)xs4all(dot)nl>
To: pgsql-hackers(at)postgresql(dot)org
Subject: underscore split to alias
Date: 2010-05-14 22:55:57
Message-ID: 8470cc81b8a6c305c942e34aaeede3b1.squirrel@webmail.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-05-14 23:08:40 Re: underscore split to alias
Previous Message Bruce Momjian 2010-05-14 22:34:40 Re: Parameter oddness; was HS/SR Assert server crash