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: [email protected] 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
