Gregory Stark <stark(at)enterprisedb(dot)com> writes:
> "Decibel!" <decibel(at)decibel(dot)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
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
In response to
pgsql-hackers by date
|Next:||From: Robert Lor||Date: 2008-07-28 23:17:56|
|Subject: Re: Review: DTrace probes (merged version) ver_03|
|Previous:||From: Andrew Dunstan||Date: 2008-07-28 23:09:08|
|Subject: Re: WITH RECUSIVE patches 0723|