pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedplpgsql language differences betw 7.4 and 8.0
2+ messages / 2 participants
[nested] [flat]
* plpgsql language differences betw 7.4 and 8.0
@ 2010-09-04 01:29 Ralph Smith <rsmith@10kinfo.com>
2010-09-04 02:48 ` Re: plpgsql language differences betw 7.4 and 8.0 Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Ralph Smith @ 2010-09-04 01:29 UTC (permalink / raw)
To: pgsql-admin
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 <http://www.10kInfo.com/;
Email: RSmith@10kInfo.com <mailto:rsmith@10kinfo.com>
_____________________________
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: plpgsql language differences betw 7.4 and 8.0
2010-09-04 01:29 plpgsql language differences betw 7.4 and 8.0 Ralph Smith <rsmith@10kinfo.com>
@ 2010-09-04 02:48 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2010-09-04 02:48 UTC (permalink / raw)
To: Ralph Smith <rsmith@10kinfo.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-09-04 02:48 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-09-04 01:29 plpgsql language differences betw 7.4 and 8.0 Ralph Smith <rsmith@10kinfo.com>
2010-09-04 02:48 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox