RE: [GENERAL] Problem with 6.5 reload

On Wed, 14 Apr 1999, Glen and Rosanne Eustace wrote:

> 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'
                         ^
Do you need another ';' here?

>    LANGUAGE 'SQL';


Brett W. McCoy           
                                         http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
Experience is what you get when you were expecting something else.