Magnus Naeslund(f) wrote: > Good! > Now convert this query so that it only evaluates the date_part thing > ONCE: > > select t.id, date_part('days',now()-t.stamp) from table_name t where > date_part('days',now()-t.stamp) > 20; > > I hope you all are kidding me in not seeing the real issue i'm trying to > show here. > > Cheers > Magnus > > >
Does this work? SELECT t.id, x.date_part FROM table_name t, (select date_part('days',now()-t.stamp)) as x WHERE x.date_part > 20; -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html