Обсуждение: plpgsql language differences betw 7.4 and 8.0

Поиск
Список
Период
Сортировка

plpgsql language differences betw 7.4 and 8.0

От
Ralph Smith
Дата:
Hi,

I'm stuck using v7.4 and more than once I've come across examples that just don't work here.
e.g.:  CREATE or  ...FUNCTION.... AS $mydelim$
      $mydelim$ doesn't work but plain old apostrophe does.
Now it looks like ELSIF is different.

Is there a location where I can find these changes?
(I don't care about 'behind the scenes internals, more at the SQL level.)

THANK!
--
 Ralph Smith
Data Architech
Web: http://www.10KInfo dot com
Email: RSmith@10kInfo.com
_____________________________

Re: plpgsql language differences betw 7.4 and 8.0

От
Tom Lane
Дата:
Ralph Smith <rsmith@10kinfo.com> writes:
> I'm stuck using v7.4 and more than once I've come across examples that
> just don't work here.
> e.g.:  CREATE or  ...FUNCTION.... AS $mydelim$
>       $mydelim$ doesn't work but plain old apostrophe does.
> Now it looks like ELSIF is different.

> Is there a location where I can find these changes?

Try the release notes.
http://www.postgresql.org/docs/9.0/static/release.html

BTW, you need to think seriously about getting "unstuck".
7.4's remaining support lifespan is measured in days, not weeks.
You need to be making plans *now* to move to 8.2 or later.

            regards, tom lane