Forwarded to the HACKER list.
		-DEJ

> -----Original Message-----
> From:	Anton Stöckl [SMTP:tony@cys.de]
> Sent:	Tuesday, May 05, 1998 7:57 AM
> To:	PostgreSQL Questions
> Subject:	[QUESTIONS] arrays
> 
> Hi there,
> 
> I just started playing around with arrays and have a question:
> 
> Can I select all values of an array without the braces and delimiters?
> 
> Like:
> 
> apache_conf=> select directive_key from vhosts;
> directive_key
> -------------
> {1,2}        
> (1 row)
> 
> apache_conf=> select all_array_values(directive_key) from vhosts;
> directive_key
> -------------
>             1
>             2        
> (2 row)
> 
> I don't know how many elements the array holds, so I can't just use
> the array[n] notation (would I need an array if I knew?).
> I could parse it in my program, but in that case, I wouldn't need an
> array, too (but could use a varchar type).
> 
> There is an additional array question coming to my mind:
> Can I insert values into the array (and delete from it), or do I have
> to override it with the new values.
> 
> Sorry if there are answers in the manuals, I just found the
> description
> how to create an array.
> 
> Any pointers appreciated, Tony
> 
> -- 
> ----------C-Y-B-E-R-S-O-L-U-T-I-O-N-S----------------
> Anton Stöckl                    mailto:tony@cys.de
> CyberSolutions GmbH             http://www.cys.de
> Frankfurter Ring 193A           Phone +49 89 32369223
> 80807 Muenchen                  Fax   +49 89 32369220
> ------W-E----M-A-K-E----I-T----P-O-S-S-I-B-L-E-------
> --
> Official WWW Site: http://www.postgresql.org
> Online Docs & FAQ: http://www.postgresql.org/docs
> Searchable Lists: http://www.postgresql.org/mhonarc

Thu, 7 May 1998 11:00:09 -0500
"Jackson, DeJuan" <djackson@cpsgroup.com>
RE: [QUESTIONS] arrays