Skip site navigation (1) Skip section navigation (2)

Re: Returning arbitrary row sets from a function

From: "Gerard Mason" <gerardmason(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Returning arbitrary row sets from a function
Date: 2003-12-16 15:16:43
Message-ID: BAY7-F96SIeSOm3WsTi0003b64a@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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


Responses

pgsql-novice by date

Next:From: Keith C. PerryDate: 2003-12-16 15:26:09
Subject: Re: [NOVICE] PostgreSQL Training
Previous:From: Tom LaneDate: 2003-12-16 14:28:04
Subject: Re: Returning arbitrary row sets from a function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group