Postgres Pro
Downloads
Home   >   mailing lists

Re: View's plan not taking advantage of WHERE? - Mailing list pgsql-general

From Mike Summers
Subject Re: View's plan not taking advantage of WHERE?
Date
Msg-id CAJGeMG9rfUYN3wm4G7S9FhNB1eFdxEZuOr+bLPwpgNEOqvx_eA@mail.gmail.com
Whole thread Raw
In response to Re: View's plan not taking advantage of WHERE?  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: View's plan not taking advantage of WHERE?  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view
From what I'm reading the View is frozen when it's created, including it's plan, and the usual solution is to use a set returning function... is this not true?

I've double checked all schemas and the view is only defined once.

Thanks.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: View's plan not taking advantage of WHERE?
Next
From: Scott Marlowe
Date:
Subject: Re: View's plan not taking advantage of WHERE?