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
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