Skip to content

Tilda Database functions: Array Converters

Jump to bottom
Laurent Hasson edited this page Sep 17, 2019 · 2 revisions

<-- Common Helper Database Functions

Source code in PostgreSQL.helpers-start.sql

Array Converters

Postgres support powerful Array capabilities, but many external tools (such as open source ETL solutions Pentaho Kettle or Talend) don't. For this to work, we need automatic conversions from arrays to strings and vice-versa. This happend transparently.

-- need better examples here!
TILDA.strToArray(text);
TILDA.strToArray(varchar)
TILDA.StrNativeArrayToArray(text) returns text[]
Clone this wiki locally