Why to use PG:pic.twitter.com/C9LPDg3Z9t
You can add location information to your Tweets, such as your city or precise location, from the web and via third-party applications. You always have the option to delete your Tweet location history. Learn more
@saoili @samphippen Why on earth it decides that is better than "I know this column is definitely a string so lets cast the 0"? ¯\_(ツ)_/¯
@saoili @samphippen IMO the correct behavior is what PG does, which is error w/ a type mismatch and require an explicit cast
@sgrif @saoili @samphippen PG also has some nice automatic conversions:
select now()::date = '2015-10-19';
?column?
----------
t
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.