From: Josh Berkus <josh@agliodbs.com>
To: Bill Moran <wmoran@potentialtech.com>
To: Shridhar Daithankar <shridhar@frodo.hserus.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: On the performance of views
Date: Thu, 29 Jan 2004 10:41:19 -0800
Message-ID: <200401291041.19017.josh@agliodbs.com> (raw)
In-Reply-To: <4017DD0D.6040200@potentialtech.com>
References: <40152FF2.8000007@potentialtech.com>
<4017764B.3080903@frodo.hserus.net>
<4017DD0D.6040200@potentialtech.com>
Shridhar, Bill,
> > Is MSSQL allows to mix rows of two types in single function invocation,
> > I am sure that would be a hell lot of porting trouble..
There's also the question of whether or not PG would every want to do this.
Frankly, as a once-upon-a-time SQL Server application developer, I found the
ability to return multiple rowsets from a single SQL Server procedure pretty
useless, and a source of endless debugging if we tried to implement it.
> 1) Returning a homogenious set of rows, but the composition of those rows
> will not be known until run time, as a different set of logic will be
> done depending on the values of some parameters.
This can be done with Set Returning Functions. The issue is that the call to
the function requires special syntax, and the program calling the function
must know what columns are going to be returned at the time of the call.
Hmmm, is that clear or confusing?
> #2 has to be solved at the application level. My solution so far has
> been to create multiple Postgres functions, call each one in turn, join
> the results in C, and return them as a structure via SOAP to the client.
> May not be the easiest way to get it working, but it's working so far.
> (although I'm always open to suggestions if someone knows of a better
> way)
See my comment above. I frankly don't understand what the use of a
non-homogenous recordset is. Can you explain?
--
Josh Berkus
Aglio Database Solutions
San Francisco
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-sql@postgresql.org
Cc: josh@agliodbs.com, wmoran@potentialtech.com, shridhar@frodo.hserus.net, pgsql-performance@postgresql.org
Subject: Re: On the performance of views
In-Reply-To: <200401291041.19017.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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