view problem

===================================================================
This message has been sent to a DEAD mailing list, and subsequently
reforwarded to the proper one: pgsql-interfaces(at)postgresql(dot)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(at)spy(dot)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. ____________