On 3 August 2018 at 01:16, Oliver Kohll <oliver@agilechilli.com> wrote:
> Ah thanks David, at least I know what it is now. I don't think I have any
> set returning functions though will double check in case there's a joined
> view that has one. Perhaps it could be the something to do with cross
> product which similarly creates multiple rows on the right for each row on
> the left side.
postgres=# select proretset from pg_proc where proname = 'regexp_matches';
proretset
-----------
t
t
(2 rows)
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services