On Mar 28, 2006, at 1:59 PM, Scott Marlowe wrote:
Generally you'll find the PostgreSQL gotchas are of the sort that make
you go "oh, that's interesting" and the MySQL gotchas are the kind
that
make you go "Dear god, you must be kidding me!"
But that's just my opinion, I could be wrong.
I nominate this for "quote of the month". :-)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match