Search Postgresql Archives

Re: Advantages of PostgreSQL over MySQL 5.0

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



To go slightly OT, I have the current displeasure of becomming
acquainted with Sybase which has ideas about being flexible with
standards (and sanity) much like MySQL.

The first of the two intentional "helpful" features I have come across
so far is that inserting (or updating) char/varchar columns with
strings that are too long silently results in a truncated string.

The second is that in where clauses, NULL = NULL is true. (waits for
you to get up off the floor) Apparently it didn't use to be like that,
but the "feature" was added due to customer requests... What's worse
is that Sybase is not even internally consistent - FALSE = FALSE in
the join clause does not cause a match.

Truly horrible. Of course there are runtime parameters you can set to
get more ansi-ish behaviour, but by the time you realise this, there
may already production code that relies on the behaviour...


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux