Re: Problem trying to load trigger - Mailing list pgsql-general

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@sss.pgh.pa.us> wrote:
> Michael Gould <mgould@intermodalsoftwaresolutions.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>