Is it possible to append a WHERE clause in SELECT in plpgsql?

Question

I have a function with several IN params.

I need to build a complex select and use the params in the WHERE CLAUSE.

Is there any way I can add some conditioning like this:

if ($1 > 0)  then
 condition1 ='col1 = $1';
end if;

SELECT * from table1 WHERE || condition1 ;

score 1 · Answer 1 · answered Jun 23 '11 at 12:23

1

You can use dynamic SQL

answered Jun 23 '11 at 12:23

Denis de Bernardy

score 0 · Answer 2 · answered Jun 23 '11 at 12:25

Yes, you can execute dynamic commands using "execute"

if ($1 > 0)  then
 condition1 ='col1 = '||$1::varchar;
end if;

execute 'select * from table1 where '||condition1;

2 Answers2