Re: 8.1 vs 8.2.1 view optimization - Mailing list pgsql-general

From Tom Lane
Subject Re: 8.1 vs 8.2.1 view optimization
Date
Msg-id 26458.1168983637@sss.pgh.pa.us
Whole thread Raw
In response to 8.1 vs 8.2.1 view optimization  (Nathan Bell <nathanb@actarg.com>)
Responses Re: 8.1 vs 8.2.1 view optimization
List pgsql-general
Nathan Bell <nathanb@actarg.com> writes:
> Firing up 8.2.1 I notice that sub-items in a view are optimized out if
> they aren't being selected.

You mean "not optimized out", I suppose.  Declare your function as
non-volatile if you want the optimizer to assume it's OK to discard.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dynamic loading of Perl Code in Postgres functions
Next
From: Jorge Godoy
Date:
Subject: [1/2 OFF] Varlena.com inaccessible from .br (Blocked?)