Postgres Pro
Downloads
Home   >   mailing lists

WITH SELECT * FROM function(
) WHERE etc - Mailing list pgsql-general
From InterRob
Subject WITH SELECT * FROM function(
) WHERE etc
Date
Msg-id 671e36b0909290300x51895efdw6790f458676a6a42@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
Dear list,

Say, I wish to have a function returning a record, taking a row as parameter. However, from a performance perspective, I wish to be able to perform this query only on a subset by using a WHERE-clause.

I can only think of the following approach:

WITH ss AS ( SELECT * FROM my_table) SELECT * FROM my_function(ss) WHERE ss.field1 > 100

Question is: does the optimizer apply this WHERE-clause to the WITH-SELECT (resulting in "ss")?


Rob

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Collation in ORDER BY not lexicographical
Next
From: Sam Mason
Date:
Subject: Re: bulk inserts