Search Postgresql Archives

Re: PostgreSQL Array Use

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mar 3, 2008, at 12:42 PM, Josh Trutwin wrote:

On Mon, 03 Mar 2008 10:42:50 -0700
dmp <danap@xxxxxxxxxxx> 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@xxxxxxxxxx
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




---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux