RE: [GENERAL] Problem with 6.5 reload

Glen and Rosanne Eustace <agree@godzone.net.nz>

From: Glen and Rosanne Eustace <agree@godzone.net.nz>
To: "'Brett W. McCoy'" <bmccoy@lan2wan.com>
Cc: "'pgsql-general'" <pgsql-general@postgreSQL.org>
Date: 1999-04-14T00:30:11Z
Lists: pgsql-general
> > CREATE FUNCTION next_target ( )
> >    RETURNS int4 AS
> >    'update global set next_target=next_target+1;select
> > next_target from global'
>                          ^
> Do you need another ';' here?
> 
> >    LANGUAGE 'SQL';

Thanks Brett, you are correct.

It seems that prior to 6.5, this wasn't necessary but now is.

Glen.