Gregory Stark <stark@enterprisedb.com> writes:
> "Decibel!" <decibel@decibel.org> 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