Gregory Stark <[EMAIL PROTECTED]> writes:
> "Decibel!" <[EMAIL PROTECTED]> writes:
>> Do we really want to be making it easier for people to wrap numbers in
>> quotes?
> Currently wrapping numbers in quotes is really the way Postgres expects to get
> them.
Really?
regression=# select '2' + '2';
ERROR: operator is not unique: unknown + unknown
LINE 1: select '2' + '2';
^
HINT: Could not choose a best candidate operator. You might need to add
explicit type casts.
We've worked really hard to get to a point where interpretation of
literals mostly behaves unsurprisingly. I think most people would
find it surprising to think that quoting a number is the preferred
way to represent it.
regards, tom lane
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
