Igor Korot <ikorot01@gmail.com> writes: > On Sat, Mar 22, 2025, 8:58 PM David G. Johnston <david.g.johnston@gmail.com> > wrote: >> Then read the psql docs. Your version has \if and you’ll find server >> version listed as the available client variables.
> I was hoping for something like
> If server_version >= X: > CREATE OR REPLACE TRIGGER...
psql's \if doesn't (yet) have any native expression evaluation ability, so you have to farm out the ">=" comparison. The psql docs suggest relying on the server to do it, which would go along the lines of
select current_setting('server_version_num')::int >= 130000 as v13 \gset \if :v13 ... do something \else ... do something else \endif
Thank for the code.
2 things, however.
1. Apparently CREATE OR RELACE TRIGGER syntax is available since v17, which is the current one. So I hadto adjust the numbers.. 😀
2. Is there a way to do CREATE TRIGGER IF NOT EXIST for the earlier version?
Thank you.
You could also do the comparison client-side, along the lines of
