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
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 |