115 reputation
15
bio website
location United States
age
visits member for 2 years, 6 months
seen Oct 15 '13 at 21:45

Jul
21
awarded  Popular Question
Oct
11
awarded  Notable Question
Sep
25
comment COALESCE returning NULL when there are no records
This was the simplest answer, thanks @michael-sqlbot.
Sep
25
accepted COALESCE returning NULL when there are no records
Sep
25
comment COALESCE returning NULL when there are no records
They aren't redundant, if you look they're on different tables.
Sep
25
comment COALESCE returning NULL when there are no records
BTW, I've also tried replacing COALESCE with IFNULL without any luck.
Sep
25
asked COALESCE returning NULL when there are no records
Jan
28
awarded  Popular Question
Apr
22
awarded  Student
Apr
4
awarded  Supporter
Apr
4
awarded  Scholar
Apr
4
accepted Compare a date and a timestamp with time zone with now() in the same query?
Apr
4
comment Compare a date and a timestamp with time zone with now() in the same query?
I get the following error with your query: [Err] ERROR: operator does not exist: text > timestamp with time zone. This was my original query on all databases until I ran into this original error when querying this one machine with expiration stored as a timestamp+timezone. I'm also querying a view, does the view convert datatypes to text or something?
Apr
3
asked Compare a date and a timestamp with time zone with now() in the same query?