Re: MySQL Compatibility WAS: 8.5 release timetable, again - Mailing list pgsql-hackers

From Greg Stark
Subject Re: MySQL Compatibility WAS: 8.5 release timetable, again
Date
Msg-id 407d949e0908261522m26e27ae3l76db0d7945bfb9fc@mail.gmail.com
Whole thread Raw
In response to Re: MySQL Compatibility WAS: 8.5 release timetable, again  (Greg Stark <gsstark@mit.edu>)
Responses Re: MySQL Compatibility WAS: 8.5 release timetable, again  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: MySQL Compatibility WAS: 8.5 release timetable, again  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
2009/8/26 Greg Stark <gsstark@mit.edu>:
>> PostgreSQL does not automatically cast data between BOOLEAN and INT
>> PostgreSQL does not automatically cast data between INT and VARCHAR/CHAR
>
> These are things we've gone out of our way to NOT do. At some cost
> too. Being loose here makes it easy to miss errors in your SQL.


Actually it always bothered me that we don't have implicit casts from
integer->boolean. I can't see any ambiguity or unintentional effects
this would cause problems with. Am I missing something?


-- 
greg
http://mit.edu/~gsstark/resume.pdf


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: MySQL Compatibility WAS: 8.5 release timetable, again
Next
From: Bruce Momjian
Date:
Subject: Re: MySQL Compatibility WAS: 8.5 release timetable, again