view problem

===================================================================
This message has been sent to a DEAD mailing list, and subsequently
reforwarded to the proper one: pgsql-interfaces@postgresql.org
===================================================================


    Hey, can someone tell me why this happens and/or possibly a better way
to do it?:

misc=> create view fifteen as
misc->     select * from rstat where
misc->     (
misc->         time>datetime(now())-'1 minute'::timespan and
misc->         time<datetime(now())+'1 minute'::timespan
misc->     ) or
misc->     (
misc->         time>datetime(now())-'16 minutes'::timespan and
misc->         time<datetime(now())-'15 minutes'::timespan
misc->     )
misc-> ;
ERROR:  DefineQueryRewrite: rule plan string too big.

    I'm taking samples of rstat, and I want to be able to pull out one
current sample, and one sample from fifteen minutes ago.  I've tried this with
between, and I tried it with the date truncation stuff, just won't take my
view.  I also tried making a function that did something similar, 'cept it
produces a strange output, (just returns OIDs?).  TIA

--
SA, software.net         My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________