Re: Determine server version from psql script

[Christophe Pettus]

> On Mar 23, 2025, at 18:08, Igor Korot <ikoro...@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 )