Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f) - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f)
Date
Msg-id CAKFQuwapfoxHYsHBygGHauV22CcHiRBYC5MA6zsKFC5XgKXqbg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f)  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
Tree view
On Fri, Jan 27, 2017 at 3:13 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
In any case the more idiomatic way of writing your query these days (since 9.4 came out) is:

SELECT *
FROM pg_constraint pc
LEFT JOIN LATERAL generate_series(1, case when contype in ('f','p','u') then array_upper(pc.conkey, 1) else 0 end) gs ON true;


Supposedly ​should work back to 9.3​, mis-remembered when LATERAL was released.

David J.

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f)
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] Typo in comment in postgres_fdw.c