Re: array_agg to array

From: Philipp Kraus <philipp(dot)kraus(at)tu-clausthal(dot)de>
To: Torsten Förtsch <tfoertsch123(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: array_agg to array
Date: 2018-05-16 07:15:07
Message-ID: 757406EB-48C3-4C2A-842A-E835E6267657@tu-clausthal.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Am 16.05.2018 um 09:10 schrieb Torsten Förtsch <tfoertsch123(at)gmail(dot)com>:
>
> select array_agg(i[1]) as e from regexp_matches( 'H2O', '[0-9]*[A-Z][a-z]?\d*|\((?:[^()]*(?:\(.*\))?[^()]*)+\)\d+', 'g') t(i);

perfect, this helps with the t(i) call

Phil

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2018-05-16 08:48:11 Re: Out of memory error with PG10.3, 10.4 but not 9.3.19
Previous Message Torsten Förtsch 2018-05-16 07:10:54 Re: array_agg to array