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