| From: | Thomas Boussekey <thomas(dot)boussekey(at)gmail(dot)com> |
|---|---|
| To: | hamann(dot)w(at)t-online(dot)de |
| Cc: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: SQL questiom |
| Date: | 2022-01-21 10:36:10 |
| Message-ID: | CALUeYmdPS=sYsC+1=wYn2rv_+LymSP3wW0d8YLFMzL21B_ED8w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Le ven. 21 janv. 2022 à 11:14, <hamann(dot)w(at)t-online(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaozhong SHI | 2022-01-21 11:42:32 | PgAdmin is struggling and can we configure it so that it works better |
| Previous Message | hamann.w | 2022-01-21 10:13:57 | SQL questiom |