[GENERAL] 8.1 vs 8.2.1 view optimization

2007-01-16 Thread Nathan Bell
for illistration purposes only, and is made only to take time. Thanks in advance for any help, Nathan Bell IT Engineer Action Target, Inc. create trusted language 'plpgsql' handler plpgsql_call_handler lancompiler 'PL/pgSQL'; create table small ( only_item int4 ); cre

Re: [GENERAL] 8.1 vs 8.2.1 view optimization

2007-01-16 Thread Nathan Bell
the sub-select to a different non-volatile view or do I need to create a non-volatile function that returns the result? Thanks for the help. Tom Lane wrote: Nathan Bell <[EMAIL PROTECTED]> writes: Firing up 8.2.1 I notice that sub-items in a view are optimized out if they