Re: [SQL] calculated expressions and index use

2003-01-30 Thread Arjen van der Meijden
A very dirty work around could be: select * from foo where created+at >= (select now() - '1 hour'::interval); Or perhaps this already works: select * from foo where created+at >= (now() - '1 hour'::interval); Pavel Hlavnicka wrote: Hi all, I use simple sql statement like this select * from foo

Re: [SQL] Boolean to int

2002-07-08 Thread Arjen van der Meijden|Moderator P&W / Serverbeheer
ether the query itself is correct. Goodluck > -Oorspronkelijk bericht- > Van: Stephane Schildknecht [mailto:[EMAIL PROTECTED]] > Verzonden: vrijdag 5 juli 2002 15:39 > Aan: Arjen van der Meijden > CC: [EMAIL PROTECTED] > Onderwerp: Re: [SQL] Boolean to int > > >