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: (view raw or whole 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?


>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 ([]) by 
>with Microsoft SMTPSVC(5.0.2195.6713); Tue, 16 Dec 2003 06:33:44 -0800
>Received: from ([]) by with 
>Microsoft SMTPSVC(5.0.2195.6824); Tue, 16 Dec 2003 06:33:43 -0800
>Received: from ([] 
> with esmtp (Exim 4.24)id 1AWGCE-00055p-BQ; Tue, 16 Dec 
>2003 08:29:10 -0600
>Received: from localhost ( [])by 
> (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 ([]) by localhost 
>( []) (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 (unknown [])by 
> (Postfix) with ESMTP id 8C331D1DC11for 
><pgsql-novice(at)postgresql(dot)org>; Tue, 16 Dec 2003 10:28:01 -0400 (AST)
>Received: from (tgl(at)localhost [])by 
> (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: 
>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
>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 -
>X-AntiAbuse: Original Domain -
>X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12]
>X-AntiAbuse: Sender Address Domain -
>Return-Path: pgsql-novice-owner+M9061(at)postgresql(dot)org
>X-OriginalArrivalTime: 16 Dec 2003 14:33:43.0294 (UTC) 
>"Gerard Mason" <gerardmason(at)hotmail(dot)com> writes:
> > That seems to be what the documentation is suggesting the return type 
> > 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!


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-2015 The PostgreSQL Global Development Group