On Fri, Jan 27, 2017 at 3:13 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)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.