On Apr 30, 2014, at 1:00 PM, Petite Abeille <petite.abei...@gmail.com> wrote:
>
> On Apr 30, 2014, at 2:22 PM, John McKown <john.archie.mck...@gmail.com> wrote:
>
>> PostgreSQL likewise returns 0 for 2/4 and .5 for 2/4.0 . This is likely a
>> part of the SQL standard.
>
> Just to be contrarian, Oracle doesn’t and returns 0.5. Ah!
>
Given Oracle’s legacy, it might be that “2” defaults to a “numeric” type,
rather than an integer.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have it, but showing
it to the wrong people has the tendency to make them feel uncomfortable." --
Angela Johnson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users