Postgres Pro
Downloads
Home   >   mailing lists

Re: Simple view confuses PostgreSQL query planning - Mailing list pgsql-sql

From Manuel Sugawara
Subject Re: Simple view confuses PostgreSQL query planning
Date
Msg-id m3zn824vw5.fsf@conexa.fciencias.unam.mx
Whole thread Raw
In response to Re: Simple view confuses PostgreSQL query planning  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Get rid of the CASEs (perhaps you could wrap them into functions
> declared STRICT) and the view would be flattenable.

Will do that. Thanks.

Regards,
Manuel.

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Simple view confuses PostgreSQL query planning
Next
From: Tom Lane
Date:
Subject: Re: OR clause causing strange index performance