Re: array UNNESTed to rows stable with respect to order?

From: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: array UNNESTed to rows stable with respect to order?
Date: 2018-04-18 06:08:51
Message-ID: 20180418080851.13092s2p6i83irwg@www.gelassene-pferde.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Zitat von Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>:

> I think you are looking for `WITH ORDINALITY` (in pg 9.4+). For
> instance you could rewrite your first CTE like so:

Thanks for the hint.

Kind regards

--
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0x8F70EFD2D972CBEF

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thiemo Kellner, NHC Barhufpflege 2018-04-18 06:26:04 Re: rehashing catalog cache id 14 for pg_opclass; 17 tups, 8 buckets
Previous Message Thiemo Kellner, NHC Barhufpflege 2018-04-18 06:08:22 Re: array UNNESTed to rows stable with respect to order?