Hi,
[code]
SELECT current_setting('server_version_num')::int > 130000 as v13
\gset
\if :v13
CREATE OR REPLACE TRIGGER playersinleague_insert AFTER INSERT ON
playersinleague WHEN new.current_rank IS NULL
BEGIN
UPDATE playersinleague SET current_rank = 1 + (SELECT
coalesce( max( current_rank ), 0 ) FROM playersinleague WHERE id =
new.id) WHERE rowid = new.rowid;
psql:draft_pg.sql:44265: ERROR: syntax error at or near "TRIGGER"
LINE 1: CREATE OR REPLACE TRIGGER playersinleague_insert AFTER INSER...
^
[/code]
What am I doing wrong?
Thank you.
On Sun, Mar 23, 2025 at 12:53 PM David G. Johnston
<david.g.johns...@gmail.com> wrote:
>
> On Sunday, March 23, 2025, David G. Johnston <david.g.johns...@gmail.com>
> wrote:
>>
>> On Sunday, March 23, 2025, Igor Korot <ikoro...@gmail.com> wrote:
>>>
>>>
>>> 2. Is there a way to do CREATE TRIGGER IF NOT EXIST for the earlier version?
>>
>>
>> No. You have to drop the trigger if it does exist and then create the new
>> one.
>
>
> Well, you can always query the catalogs directly to answer the question “does
> this trigger exist”.
>
> David J.
>
