agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Markus Schaber <schabios@logi-track.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Gavin Sherry <swm@linuxworld.com.au>
Cc: Neil Conway <neilc@samurai.com>
Cc: pgsql-hackers@postgresql.org
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Where are we on stored procedures?
Date: Fri, 25 Feb 2005 19:21:02 +0100
Message-ID: <421F6C8E.40804@logi-track.com> (raw)
In-Reply-To: <29295.1109295241@sss.pgh.pa.us>
References: <26903.1109275995@sss.pgh.pa.us>
<Pine.LNX.4.58.0502250952150.23330@linuxworld.com.au>
<29295.1109295241@sss.pgh.pa.us>
Hi, Tom,
Tom Lane schrieb:
> Yeah, but only because you have to do it explicitly. I was wondering
> whether we couldn't bury that mechanism under the hood. (In particular,
> given the improved support in 8.0 for anonymous record types, we could
> in theory have the backend invent a record type on-the-fly to match
> whatever list of OUT parameters a particular function has.)
It would not be necessarily on the fly, at least in the first step we
possibly get away with declaraing the returned tuples at creation time
and implicitly creating those tuple types. The declaration could be like
"returns (touchedrows int, somethingelse datetime), setof (article int,
description text)" for a function/method that has two resultsets, one of
those with always one row.
markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios@logi-track.com | www.logi-track.com
Attachments:
[application/pgp-signature] signature.asc (255B, ../421F6C8E.40804@logi-track.com/2-signature.asc)
download
view thread (15+ messages) latest in thread
Message-ID: <421F6C8E.40804@logi-track.com>
Permalink: ../421F6C8E.40804@logi-track.com/
Also on: postgresql.org/message-id/421F6C8E.40804@logi-track.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: schabios@logi-track.com, tgl@sss.pgh.pa.us, swm@linuxworld.com.au, neilc@samurai.com, pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Where are we on stored procedures?
In-Reply-To: <421F6C8E.40804@logi-track.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox