[GENERAL] DefineQueryRewrite: rule plan string too big-- workaround?

2000-02-03 Thread mathprof
I created what I thought was a fairly simple view, and got back: ERROR: DefineQueryRewrite: rule plan string too big. Is there any workaround for this? I'm pretty sure the view is correct otherwise-- if I edit it even slightly, the "CREATE" goes through fine and the view works great (well, almo

[GENERAL] SELECT LIMIT and the last rows of a query

2000-02-19 Thread mathprof
The command: SELECT (query) LIMIT m,n gives m rows of the query's response, starting at row n+1, while SELECT (query) LIMIT m gives the first m rows of the query's response (starting at row 1). Is there any easy way to get the *last* m rows of a query? I tried: SELECT (query) LIMIT 5, -5 i