Re: [GENERAL] Rewriting select statements

2009-10-30 Thread Phil Cairns
Tom Lane wrote: > "Phil Cairns" writes: > > I want to have the server do this: > > If the query has no where clause, use a where clause of "where 1=0". > > > Is this possible? > > It's doubtless *possible*, but if you're asking for

[GENERAL] Rewriting select statements

2009-10-30 Thread Phil Cairns
5 million rows. This view is not queried without a where clause during the normal execution of the program, so to save between 6 and 20 minutes of startup time depending on server load, I'd like to be able to add the where clause. Thanks for any help, Phil Cairns. -- Sent via pgsql-general m