daveg <daveg@sonic.net> wrote:
> On Tue, Sep 22, 2009 at 10:27:19AM +0530, Jeevan Chalke wrote:
>>
>> It seems that Oracle reads formatting string from right-to-left.
>> Here are few results:
>> ('number','format') ==> Oracle PG
>> --------------------------------------------
>> ('34,50','999,99') ==> 3450 340
>> ('34,50','99,99') ==> 3450 3450
>> ('34,50','99,999') ==> Invalid Number 3450
>> ('34,50','999,999') ==> Invalid Number 340
>
> It seems worse to to give a wrong answer silently then to throw an
> error. What we do now seems sort of MySqlish.
I agree with David on that.
Further, it seems to me that functions which are there only for Oracle
compatibility (i.e., they are not part of the SQL standard and are not
particularly sensible, but are popular in Oracle) should behave like
the corresponding Oracle function. An argument could even be made for
"bug compatibility" for such functions, at least to some extent;
although we're not talking about that here -- the Oracle results seem
more sane than current PostgreSQL behavior..
-Kevin