[GENERAL] PostgreSQL Array Use

2008-03-03 Thread dmp
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? 2. Single or

Re: [GENERAL] PostgreSQL Array Use

2008-03-03 Thread Karsten Hilbert
On Mon, Mar 03, 2008 at 10:42:50AM -0700, dmp wrote: 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. 1. What Size, 10 or 100's, 1000's of

Re: [GENERAL] PostgreSQL Array Use

2008-03-03 Thread Josh Trutwin
On Mon, 03 Mar 2008 10:42:50 -0700 dmp [EMAIL PROTECTED] 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.

Re: [GENERAL] PostgreSQL Array Use

2008-03-03 Thread Erik Jones
On Mar 3, 2008, at 12:42 PM, Josh Trutwin wrote: On Mon, 03 Mar 2008 10:42:50 -0700 dmp [EMAIL PROTECTED] 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

Re: [GENERAL] PostgreSQL Array Use

2008-03-03 Thread Karsten Hilbert
On Mon, Mar 03, 2008 at 01:22:17PM -0600, Erik Jones wrote: Where are you getting this information. IMO the OP wanted to know how people *use* arrays, not how one *can* use arrays. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

Re: [GENERAL] PostgreSQL Array Use

2008-03-03 Thread Josh Trutwin
On Mon, 3 Mar 2008 20:48:55 +0100 Karsten Hilbert [EMAIL PROTECTED] wrote: On Mon, Mar 03, 2008 at 01:22:17PM -0600, Erik Jones wrote: Where are you getting this information. IMO the OP wanted to know how people *use* arrays, not how one *can* use arrays. That was my thought, sort of a

Re: [GENERAL] PostgreSQL Array Use

2008-03-03 Thread Erik Jones
On Mar 3, 2008, at 2:05 PM, Josh Trutwin wrote: On Mon, 3 Mar 2008 20:48:55 +0100 Karsten Hilbert [EMAIL PROTECTED] wrote: On Mon, Mar 03, 2008 at 01:22:17PM -0600, Erik Jones wrote: Where are you getting this information. IMO the OP wanted to know how people *use* arrays, not how one

Re: [GENERAL] PostgreSQL Array Use

2008-03-03 Thread eKIK
1. What Size, 10 or 100's, 1000's of elements? 100 elements 2. Single or Multi-Dimensional? 2-dimensional 3. What data types? integers ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] PostgreSQL Array Use

2008-03-03 Thread TJ O'Donnell
I use arrays of integers, double or numeric, and text. They are 1 or 2 dimensional. They are usually limited to 100 elements in one dimension and 10 in the other. TJ O'Donnell http://www.gnova.com ---(end of broadcast)--- TIP 1: if posting/reading

Re: [GENERAL] PostgreSQL Array Use

2008-03-03 Thread dmp
I was slightly confused. I'm really trying to identify what type of support the project should provide to array types. Just from the input so far, it looks like more needs to be done. If 100's to 1000's of elements are in an array type, the application is going to have some problems. Presently it