|
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
|
