Why to use PG:pic.twitter.com/C9LPDg3Z9t
-
@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 -
@sgrif@saoili@samphippen & it'll fail if the syntax is off: select now()::date = '2015-10'; ERROR: invalid input syntax for type date - 1 more reply
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.