Le ven. 21 janv. 2022 à 11:14, <haman...@t-online.de> 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
<https://www.postgresql.org/docs/current/sql-createfunction.html> to
perform this operation
HTH,
Thomas
