RE: [GENERAL] Problem with 6.5 reload - Mailing list pgsql-general

From Glen and Rosanne Eustace
Subject RE: [GENERAL] Problem with 6.5 reload
Date
Msg-id 000d01be860d$f5747720$0101a8c0@agree-1.godzone.net.nz
Whole thread Raw
In response to RE: [GENERAL] Problem with 6.5 reload  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
List 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.


pgsql-general by date:

Previous
From: Guo Ge
Date:
Subject: about transaction
Next
From: James Thompson
Date:
Subject: Would this project be of interest to anyone?