Postgres Pro
Downloads
Home   >   mailing lists

Re: where clause + function, execution order - Mailing list pgsql-performance

From Tom Lane
Subject Re: where clause + function, execution order
Date
Msg-id 5921.1321027215@sss.pgh.pa.us
Whole thread Raw
In response to where clause + function, execution order  (Sorin Dudui <sd@wigeogis.com>)
List pgsql-performance
Tree view 
Sorin Dudui <sd@wigeogis.com> writes:
> I am wondering when the where clause (a.x = 'value') is executed. After the select statement in the function
finishes?Or is it appended at the select statement in the function? 

EXPLAIN is your friend ...

In this case the function looks inline-able, so reasonably recent
versions of PG should do what you want.

            regards, tom lane

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: where clause + function, execution order
Next
From: Sorin Dudui
Date:
Subject: Re: where clause + function, execution order