Le ven. 21 janv. 2022 à 11:14, <hamann.w@xxxxxxxxxxx> a écrit :
Hi,
I am using a query pretty often that looks like
SELECT <<fixed columns from tables>> WHERE <<fixed join statements>> AND
<<actual select criterion>>
Is there a way (with sql or plpgsql) to convert that into
SELECT myquery('<<actual select criterion>>')
Kind regards
Wolfgang Hamann
Hello Wolfgang,
You can use a FUNCTION to perform this operation
HTH,
Thomas