problem with regexp_matches in nested funcion - Mailing list pgsql-sql

From Isaac Marco Blancas
Subject problem with regexp_matches in nested funcion
Date
Msg-id CAA2CX-11muWiocVvH3MxYC-CJcmTgSKx0Zve+XhnuSZ6S82Aaw@mail.gmail.com
Whole thread Raw
Responses problem with regexp_matches in nested funcion
List pgsql-sql
I get this error:

ERROR: functions and operators can take at most one set argument
SQL state: 0A000

When I run this:

select message as before,
       replace(message,
               array_to_string(regexp_matches(message,'\\$\\$.*?\\{tabular\\}.*?\\$\\$'), '#'),
               replace(array_to_string(regexp_matches(message,'\\$\\$.*?\\{tabular\\}.*?\\$\\$'), '#'),'tabular','array')) as later
from mdl_forum_posts
where message ~ '\\$\\$.*?\\{tabular\\}.*?\\$\\$';

I know the problem is in the second array_to_string. Some idea?

Thanks.

--
Isaac Marco Blancas

pgsql-sql by date:

Previous
From: dave
Date:
Subject: Re: Recursive merging of overlapping arrays in a column
Next
From: "David G. Johnston"
Date:
Subject: problem with regexp_matches in nested funcion