Ralph Smith <rsmith(at)10kinfo(dot)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