From: | Erik Jones <erik(at)myemma(dot)com> |
---|---|
To: | Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgreSQL Array Use |
Date: | 2008-03-03 19:22:17 |
Message-ID: | 1FD06C7C-64B3-41A7-AD92-3549BCEA8ECB@myemma.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mar 3, 2008, at 12:42 PM, Josh Trutwin wrote:
> On Mon, 03 Mar 2008 10:42:50 -0700
> dmp <danap(at)ttc-cmc(dot)net> wrote:
>
>> Hello,
>> The project MyJSQLView will provided basic support
>> for array types in PostgreSQL at the next release.
>> Information is desired from anyone that uses arrays
>> in PostgreSQL to effect this support. Just a couple
>> of questions.
>>
>> 1. What Size, <10 or 100's, 1000's of elements?
>
> 100's
>
>> 2. Single or Multi-Dimensional?
>
> Single
>
>> 3. What data types?
>
> Integers and Characters
Where are you getting this information. Here's the first three
sentences from the manual's chapter on arrays:
" PostgreSQL allows columns of a table to be defined as variable-
length multidimensional arrays. Arrays of any built-in or user-
defined base type can be created. (Arrays of composite types or
domains are not yet supported, however.)"
In addition, wrt question #1, I haven't found anything specifying any
kind of limit on the number of elements and array field can hold. I
would thus expect that you'd be more limited by 1G field size limit
via TOAST, i.e. the total size of the elements would be capped at 1G
which would be a different number of elements for different types.
Erik Jones
DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2008-03-03 19:48:55 | Re: PostgreSQL Array Use |
Previous Message | Bruce Momjian | 2008-03-03 19:16:05 | Re: Cross database joins feature request |