hadd...@mail.ru writes: > query has the following scheme > SELECT > regexp_matches('...',' (\d+)\:','g'), > regexp_matches('...','\:([\d\.]+)','g')
I'm not sure what you're expecting this to do, but what it will actually do is produce a number of rows equal to the least common multiple of the periods of the two set-returning functions. In this example it seems the first call produces 2510 rows and the second 2507 rows. Those numbers have no factors in common, so you get 6292570 rows, the same as if you'd written "select * from regexp_matches(...), regexp_matches(...)". In short, I see no bug here. The behavior of queries with multiple SRFs in the same targetlist is a bit dubious, but we're not going to change it, except perhaps by deprecating such usages altogether. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs