Re: [SQL] Re: [GENERAL] Proposed Changes to PostgreSQL - Mailing list pgsql-general

From Mathijs Brands
Subject Re: [SQL] Re: [GENERAL] Proposed Changes to PostgreSQL
Date
Msg-id 20000203072514.B174@ilse.nl
Whole thread Raw
In response to Re: [GENERAL] Proposed Changes to PostgreSQL  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
On Wed, Feb 02, 2000 at 09:57:48PM -0500, Bruce Momjian allegedly wrote:
> > > > 3) The ability to return different types of rows from a SELECT. This
> > > > is to allow implementation of ODBMS functionality where a query could
> > > > be required to instantiate objects of differing types with differing
> > > > attributes.
> > >
> > > This bothers me.  We return relational data, showing the same number of
> > > columns and types for every query.  I don't think we want to change
> > > that, even for OO.
> >
> > What aspects bother you? This is the fundamental important thing about
> > object databases.
>
> I fear it is totally against the way our API works.  How does someone
> see how many columns in the returned row?

This would probably break applications written in PHP and Perl (and
possibly others) that have their queryresults returned to them in a
numerically indexed array (index by offset). If this behaviour could
be turned off, than it shouldn't be a problem.

Mathijs

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Proposed Changes to PostgreSQL
Next
From: Chris Bitmead
Date:
Subject: Re: [SQL] Re: [GENERAL] Proposed Changes to PostgreSQL