Re: ProjectSet

From: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
To: Oliver Kohll <oliver(at)agilechilli(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: ProjectSet
Date: 2018-08-02 13:27:01
Message-ID: CAKJS1f-1uh6oxWx7sdPVqLdK6Bh65mDdCN-sPOk5BpDoKQthvg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3 August 2018 at 01:16, Oliver Kohll <oliver(at)agilechilli(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Om Prakash Jaiswal 2018-08-02 13:28:20 Error couldn't not serialize data due to concurrent read write update
Previous Message Alexandru Lazarev 2018-08-02 13:26:38 Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/)