Re: Determine server version from psql script - Mailing list pgsql-general

> On Mar 23, 2025, at 18:08, Igor Korot <ikorot01@gmail.com> wrote:
>     CREATE TRIGGER playersinleague_insert AFTER INSERT ON playersinleague WHEN new.current_rank IS NULL

The WHEN predicate has to be enclosed in parenthes:

    CREATE TRIGGER playersinleague_insert AFTER INSERT ON playersinleague WHEN ( new.current_rank IS NULL )