Hi, well mi problem is that im trying to pass a string with the select but I don't know if postgres has a function for format the query like this

select * from table1 where cod = '%' and cod2 = '%';

and then format the % simbol, because I dont want to concatenate in C all the string because is hard to do it use th epointers and all the stuff, if somebody know how to format the query , please somebody help me !