Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Huxton
Subject Re: where clause + function, execution order
Date
Msg-id 4EBD4675.2060604@archonet.com
Whole thread Raw
In response to Re: where clause + function, execution order  (Julius Tuskenis <julius@nsoft.lt>)
Responses Re: where clause + function, execution order
List pgsql-performance
Tree view 
On 11/11/11 15:54, Julius Tuskenis wrote:
> On 2011.11.11 17:38, Sorin Dudui wrote:
>> I have the following function:
>>
>> CREATE OR REPLACE FUNCTION xxx(text)
[snip]
>> LANGUAGE sql STABLE

> Function execute plan is prepared when creating it, so the "where"
> clause should check the function result not altering its execution..

Not true for SQL functions. They can be inlined, but I'm not sure if
this one will be.

What does EXPLAIN ANALYSE show for this query?


--
   Richard Huxton
   Archonet Ltd

pgsql-performance by date:

Previous
From: Julius Tuskenis
Date:
Subject: Re: where clause + function, execution order
Next
From: Tom Lane
Date:
Subject: Re: where clause + function, execution order