Re: array_agg to array

[Philipp Kraus <philipp.kraus@xxxxxxxxxxxxxxx>]

Am 16.05.2018 um 09:10 schrieb Torsten Förtsch <tfoertsch123@xxxxxxxxx>:

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: signature.asc
Description: Message signed with OpenPGP using GPGMail