[PERFORM] where clause + function, execution order

[Sorin Dudui]

Hi,

I have the following function:

===============================
CREATE OR REPLACE FUNCTION xxx(text)
  RETURNS SETOF vvvvv AS
$BODY$
select a.x, a.y,
    CASE
    WHEN strpos($1,b.x) > 0
    THEN b.x
    ELSE NULL
    END AS mp_hm
from  a LEFT JOIN  b ON a.id=b.id

                $BODY$
  LANGUAGE sql STABLE
  COST 1000
  ROWS 10000;
===============================

which I call as:

select * from xxx('test0|test1')  where a.x = 'value'


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?


Thank you,
Sorin