From: | "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com> |
---|---|
To: | Glen and Rosanne Eustace <agree(at)godzone(dot)net(dot)nz> |
Cc: | pgsql-general <pgsql-general(at)postgreSQL(dot)org> |
Subject: | RE: [GENERAL] Problem with 6.5 reload |
Date: | 1999-04-13 23:16:02 |
Message-ID: | Pine.BSI.3.91.990413191110.26449a-100000@access1.lan2wan.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Good | 1999-04-13 23:27:05 | Re: [GENERAL] Opening two databases at the same time? |
Previous Message | Brett W. McCoy | 1999-04-13 19:51:16 | Re: [GENERAL] Converting MS Access to postgres under linux. |