Re: Returning arbitrary row sets from a function

We appear to be having the same problems posting ;-)

Well, is it possible to run two different versions of postgresql
side-by-side on the same machine? I don't want to end up with a non-working
database just because I've made some stupid mistake installing a new
version, and then find that I can't revert back to the old one either.

Is it at least possible to have two different versions installed
side-by-side, even if you can only have one running at a time?

Cheers,
Gerard.

>From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>To: "Gerard Mason" <gerardmason(at)hotmail(dot)com>
>CC: pgsql-novice(at)postgresql(dot)org
>Subject: Re: [NOVICE] Returning arbitrary row sets from a function Date:
>Tue, 16 Dec 2003 09:28:04 -0500
>Received: from mc5-f1.hotmail.com ([65.54.252.8]) by mc5-s6.hotmail.com
>with Microsoft SMTPSVC(5.0.2195.6713); Tue, 16 Dec 2003 06:33:44 -0800
>Received: from noon.pghoster.com ([64.246.0.64]) by mc5-f1.hotmail.com with
>Microsoft SMTPSVC(5.0.2195.6824); Tue, 16 Dec 2003 06:33:43 -0800
>Received: from svr1.postgresql.org ([200.46.204.71] helo=postgresql.org)by
>noon.pghoster.com with esmtp (Exim 4.24)id 1AWGCE-00055p-BQ; Tue, 16 Dec
>2003 08:29:10 -0600
>Received: from localhost (neptune.hub.org [200.46.204.2])by
>svr1.postgresql.org (Postfix) with ESMTP id 5D1F5D1DBD0for
><pgsql-novice-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Tue, 16 Dec 2003
>14:28:33 +0000 (GMT)
>Received: from svr1.postgresql.org ([200.46.204.71]) by localhost
>(neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id
>43887-04 for <pgsql-novice-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Tue,
>16 Dec 2003 10:28:05 -0400 (AST)
>Received: from sss.pgh.pa.us (unknown [192.204.191.242])by
>svr1.postgresql.org (Postfix) with ESMTP id 8C331D1DC11for
><pgsql-novice(at)postgresql(dot)org>; Tue, 16 Dec 2003 10:28:01 -0400 (AST)
>Received: from sss2.sss.pgh.pa.us (tgl(at)localhost [127.0.0.1])by
>sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hBGES419021036;Tue, 16 Dec
>2003 09:28:04 -0500 (EST)
>X-Message-Info: pdGgd64CkwbpMDe6De87M4BVeULv8cLfHTWRrON5Om0=
>X-Original-To: pgsql-novice-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
>In-reply-to: <BAY7-F113qicRfZ7iHY0003b340(at)hotmail(dot)com> References:
><BAY7-F113qicRfZ7iHY0003b340(at)hotmail(dot)com>
>Comments: In-reply-to "Gerard Mason" <gerardmason(at)hotmail(dot)com>message dated
>"Tue, 16 Dec 2003 14:18:54 +0000"
>Message-ID: <21035(dot)1071584884(at)sss(dot)pgh(dot)pa(dot)us>
>X-Virus-Scanned: by amavisd-new at postgresql.org
>X-Mailing-List: pgsql-novice
>Precedence: bulk
>X-AntiAbuse: This header was added to track abuse, please include it with
>any abuse report
>X-AntiAbuse: Primary Hostname - noon.pghoster.com
>X-AntiAbuse: Original Domain - hotmail.com
>X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12]
>X-AntiAbuse: Sender Address Domain - postgresql.org
>Return-Path: pgsql-novice-owner+M9061(at)postgresql(dot)org
>X-OriginalArrivalTime: 16 Dec 2003 14:33:43.0294 (UTC)
>FILETIME=[9B0DD9E0:01C3C3E1]
>
>"Gerard Mason" <gerardmason(at)hotmail(dot)com> writes:
> > That seems to be what the documentation is suggesting the return type
>should
> > be (the examples are very incomplete!), but it doesn't work (7.1.3,
> ^^^^^
>
>That seems to be your problem ;-)
>
> > and I can't upgrade without buying a new machine, which I don't want
> > to do just yet).
>
>Surely you can upgrade. If the problem is lack of RPMs for whatever OS
>you are running, you could just compile Postgres from source.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger