Re: [GENERAL] typecast for index

2000-02-14 Thread John Henderson
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 > > > >

Re: [GENERAL] typecast for index

2000-02-13 Thread 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'