RE: [GENERAL] Problem with 6.5 reload

From: Glen and Rosanne Eustace <agree(at)godzone(dot)net(dot)nz>
To: "'Brett W(dot) McCoy'" <bmccoy(at)lan2wan(dot)com>
Cc: "'pgsql-general'" <pgsql-general(at)postgreSQL(dot)org>
Subject: RE: [GENERAL] Problem with 6.5 reload
Date: 1999-04-14 00:30:11
Message-ID: 000d01be860d$f5747720$0101a8c0@agree-1.godzone.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Guo Ge 1999-04-14 01:56:46 about transaction
Previous Message Chris Bitmead 1999-04-14 00:17:57 Re: [HACKERS] Postgres/PHP/Large Objects