Thank you Ed,
>IIRC, this is a known issue with 'IN', and that the traditional
>solution was to replace use of 'IN' with 'EXISTS', i.e.,
>
> and EXISTS (select * from userdir where user_name = username and
>towncode...)
>
>Cheers,
>Ed Loehr
>
>
>
>
John Henderson wrote:
>
> This is what I want to do:
> select user_name, date_trunc('minutes',sum(is_roundup_01(sess_time)))
> from sessions_feb2000_homer s where
> date_part('epoch',start)>'949316399' and
> date_part('epoch'
Hi y'all,
This is what I want to do:
select user_name, date_trunc('minutes',sum(is_roundup_01(sess_time)))
from sessions_feb2000_homer s where
date_part('epoch',start)>'949316399' and
date_part('epoch',start)<'951822000' and
