On Sep 23, 2008, at 7:50 PM, Tom Lane wrote:
Ralph Smith <[EMAIL PROTECTED]> writes:
I've written several user-defined functions (UDFs) for converting
dates to unix time, every which way.
... but when I try to use the function in a query
# select count(distinct username) from stats where ev
Ralph Smith <[EMAIL PROTECTED]> writes:
I've written several user-defined functions (UDFs) for converting
dates to unix time, every which way.
... but when I try to use the function in a query
# select count(distinct username) from stats where eventtime >
dtu_dmony('22 Sep 2008') ;
it never
Ralph Smith <[EMAIL PROTECTED]> writes:
> I've written several user-defined functions (UDFs) for converting
> dates to unix time, every which way.
> ... but when I try to use the function in a query
> # select count(distinct username) from stats where eventtime >
> dtu_dmony('22 Sep 2008')
I've written several user-defined functions (UDFs) for converting
dates to unix time, every which way.
They work find, ala
# select dtu_dmony('22 Sep 2008');
dtu_dmony
1222066800
(1 row)
Returns an integer.
---
Here's a typical query I often run (why I wrote
