Re: Problem trying to load trigger

Thanks to everyone who answered. Getting used to PostGres's unique syntax
can take time getting used to.

Best Regards

Michael Gould

"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)net> writes:
>> CREATE OR REPLACE FUNCTION iss.accessor_trigger() RETURNS "trigger" AS
$$
>> BEGIN
>
>> IF (TG_WHEN = 'BEFORE') THEN
>> IF (TG_OP = 'INSERT') THEN
>> NEW.createdatetime := current_timestamp
>> NEW.createuser := current_user
>
>
> You've forgotten to end these statements with semicolons ...
>
> regards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>