RE: [QUESTIONS] arrays

Forwarded to the HACKER list.
-DEJ

> -----Original Message-----
> From: Anton Stöckl [SMTP:tony(at)cys(dot)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(at)cys(dot)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