Thread: plpgsql language differences betw 7.4 and 8.0
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!
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
_____________________________
Ralph Smith
Data Architech
Web: http://www.10KInfo dot com
Email: RSmith@10kInfo.com
_____________________________
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