Postgres Pro
Downloads
Home   >   mailing lists

Re: array_agg to array - Mailing list pgsql-general

From Philipp Kraus
Subject Re: array_agg to array
Date
Msg-id 757406EB-48C3-4C2A-842A-E835E6267657@tu-clausthal.de
Whole thread Raw
In response to Re: array_agg to array  (Torsten Förtsch <tfoertsch123@gmail.com>)
List pgsql-general
Tree view

Am 16.05.2018 um 09:10 schrieb Torsten Förtsch <tfoertsch123@gmail.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
Attachment

pgsql-general by date:

Previous
From: Torsten Förtsch
Date:
Subject: Re: array_agg to array
Next
From: Michael Paquier
Date:
Subject: Re: Out of memory error with PG10.3, 10.4 but not 9.3.19