[libreoffice-users] [Base] Access PostgreSQL ARRAY types in forms

Hi all,

I am new to the list, so please excuse me if this is the wrong place or a dumb question...

I have a PostgreSQL data base and want to use LibreOffice Base as nice frontend for adding and 
modifying data.  The Postgres tables contain data arrays, like

CREATE TABLE contact (
  [...]
  email text[]
)

My problem: how can I create a form to fill in such arrays?  A simple (multiline) text field will 
try to insert its content as text, of course leading to a SQL error.

A simple solution would be using the Postgres function string_to_array() or regexp_split_to_array() 
(or even a more sophisticated Stored Procedure) in the INSERT statement, splitting the multiline 
text into array items.  However, I didn't find a way to tweak the SQL statement like this.  If this 
even possible?

Or is there an other "standard" way for dealing with array data types?

Any help will be highly appreciated!

Thanks in advance,
Albrecht.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted