Re: [GENERAL] Optimizer issue -- bad query plan?

2014-06-08 Thread Kevin Grittner
Moshe Jacobson wrote: > I can provide any other information you want, just let me know. The best thing would be to show a *self-contained* test case -- that is, starting with an empty database create tables and (if needed) the view and show a query which demonstrates the problem, all in the form

Re: [GENERAL] Trigger to convert UNIX time to timestamp without time zone.

2014-06-08 Thread Kevin Grittner
Andrew Sullivan wrote: > Are you sure you want this without time zone?  In my experience, > almost every time people think they want "without time zone" they > actually don't. +1 Basically, if you want to capture a moment in time, such as when some event happened or some measurement was taken,