Re: [HACKERS] Data type removal

From: darrenk(at)insightdist(dot)com (Darren King)
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Data type removal
Date: 1998-03-24 20:16:21
Message-ID: 9803242016.AA19838@ceodev
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > What would be the benefit of making arrays "flags on a field" instead of
> > a "field type in themselves". Seriously, how would this improve _anything_?
>
> In particular, I was thinking of the PostgreSQL module for Python. It
> has a nice interface, but needs intimate knowledge of the data types.
> Somehow, it seems to be excessively kludgy to have to have e.g. an
> int4 type, and an int4[] type. When I query a table, if one of the
> fields is an array of integers, then I either want to know that it's
> an array, or it's integer. If the returned type is "array," then I
> have to magically know that the array is filled with integers. If
> it's an integer, then I just have to recognize that it's actually a
> series of integers. With the current setup, there has to be separate
> type handlers for char(2), char(2)[], int4, int4[], int2, int2[],
> float8, float8[], etcetera. I'd rather have handlers for the base
> type, and an iterator that's used for arrays.
>

FWIW,

Haven't followed this too closely, but there is some array_iterator
code in the contrib directory coutesy of Massimo.

darrenk

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1998-03-24 21:22:51 Re: [HACKERS] Data type removal
Previous Message geek+ 1998-03-24 20:04:38 Re: [HACKERS] Data type removal