I have had no replies on this topic.
The SQL below was dumped from my 6.3.1 db and in 6.3.1 it works fine.
However the 6.5b1 psql complains that there is something wrong with the
syntax.
I have looked at \? create function, an it looks OK to me.
Can someone simply try it on another 6.5 installation to see if it fails
for you as well.
I am guessing with all the recent enhancements, the syntax has either
changed and the Docs haven't or the parser is broken.
> -----Original Message-----
CREATE FUNCTION next_target ( )
RETURNS int4 AS
'update global set next_target=next_target+1;select
next_target from global'
LANGUAGE 'SQL';
ERROR: parser: parse error at or near ""
Thanks.
--
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen Eustace, on behalf of
GodZone Internet Services, a division of AGRE Enterprises Limited.
176 Te Awe Awe St, Palmerston North, New Zealand
Ph: +64 6 356 2562, Fax: +64 6 357 0271, Mobile: 025 416 184,
http://WWW.GodZone.Net.NZ