Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1paXUE-0001fe-KH for pgsql-general@arkaria.postgresql.org; Fri, 10 Mar 2023 07:48:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1paXUD-000333-8I for pgsql-general@arkaria.postgresql.org; Fri, 10 Mar 2023 07:48:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1paXUC-00032u-Ry for pgsql-general@lists.postgresql.org; Fri, 10 Mar 2023 07:48:20 +0000 Received: from smtpout2.smhi.se ([2001:67c:274:5501::39]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1paXU9-000548-5M for pgsql-general@postgresql.org; Fri, 10 Mar 2023 07:48:19 +0000 Received: from winserv812.ad.smhi.se (winserv812.ad.smhi.se [172.16.6.44]) by smtpout2.smhi.se (Postfix) with ESMTPSA id DAE4B10A7EDA; Fri, 10 Mar 2023 07:48:14 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=smhi.se; s=20180112; t=1678434494; bh=w5CNatVZlirHkt7Ajn5LNMLpT38yN1mq2Xp6hqx/SBk=; h=From:To:CC:Subject:Date:References:In-Reply-To:From; b=YYAt70ov+x50M+dQvXJyRVlqAcLJupoDd/VoVfednY2QiVe8rEPIiMHWEQfQ3uUK3 ba3jVBQer0MkEJTK+g4Pygi9jjTz0Y4NfLNlWZqG5rTKGBrQKeP4m0osE8hbFM10tz T/aG2kMYcFYakJbg229yBH/Q+PtGO3exyx8CvTow= Received: from winserv811.ad.smhi.se (172.16.6.37) by winserv812.ad.smhi.se (172.16.6.44) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1118.25; Fri, 10 Mar 2023 08:48:14 +0100 Received: from winserv811.ad.smhi.se ([fe80::fe14:1050:c4af:853c]) by winserv811.ad.smhi.se ([fe80::fe14:1050:c4af:853c%5]) with mapi id 15.02.1118.025; Fri, 10 Mar 2023 08:48:14 +0100 From: Gustavsson Mikael To: Durumdara CC: Postgres General Subject: SV: Onfly, function generated ID for Select Query Thread-Topic: Onfly, function generated ID for Select Query Thread-Index: AQHZUx+yd9xe6qEDl065e18wor/e867znpn2///xvACAABHl3w== Date: Fri, 10 Mar 2023 07:48:14 +0000 Message-ID: <5cc66caf91ad4c888f6ffa5cb7b4435c@smhi.se> References: <7e3ca307301b4928a23c3c0a8cc2b576@smhi.se>, In-Reply-To: Accept-Language: sv-SE, en-US Content-Language: sv-SE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.66.1.221] Content-Type: multipart/alternative; boundary="_000_5cc66caf91ad4c888f6ffa5cb7b4435csmhise_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_5cc66caf91ad4c888f6ffa5cb7b4435csmhise_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Tm8sIHRoZSByZXN1bHQgd2lsbCBiZSBvcmRlcmVkIGJ5IHRoZSB3aW5kb3cgZnVuY3Rpb25zIG9y ZGVyIGNsYXVzZSBzbyBubyBhZGRpdGlvbmFsIG9yZGVyaW5nIGlzIG5lc3Nlc2FyeS4NCllvdSBj YW4gdHJ5IHRoaXMgYnkgY2hhbmdpbmcgaXQgdG8gT1ZFUihPUkRFUiBCWSBwcm9kdWN0X25hbWUp DQoNCg0KS1INCg0KTWlrYWVsDQoNCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fDQpG csOlbjogRHVydW1kYXJhIDxkdXJ1bWRhcmFAZ21haWwuY29tPg0KU2tpY2thdDogZGVuIDEwIG1h cnMgMjAyMyAwODo0MTowNg0KVGlsbDogR3VzdGF2c3NvbiBNaWthZWwNCktvcGlhOiBQb3N0Z3Jl cyBHZW5lcmFsDQrDhG1uZTogUmU6IE9uZmx5LCBmdW5jdGlvbiBnZW5lcmF0ZWQgSUQgZm9yIFNl bGVjdCBRdWVyeQ0KDQogRGVhciBNaWthZWwhDQoNCldvb29vb3cuLi4gdGhhdCBpcyBpdCENClRo YW5rIHlvdSENCg0KU0VMRUNUIHByb2R1Y3RfaWQsIHByb2R1Y3RfbmFtZSwgZ3JvdXBfaWQsIFJP V19OVU1CRVIgKCkgT1ZFUiAoT1JERVIgQlkgcHJvZHVjdF9pZCkgRlJPTSBwcm9kdWN0czsNCg0K RG9lcyB0aGlzIG1lYW4gdGhhdCBJIGhhdmUgdG8gZHVwbGljYXRlIHRoZSBvcmRlciBieSBjbGF1 c2U/DQoNClNFTEVDVCBwcm9kdWN0X2lkLCBwcm9kdWN0X25hbWUsIGdyb3VwX2lkLCBST1dfTlVN QkVSICgpDQogICAgT1ZFUiAoT1JERVIgQlkgcHJvZHVjdF9pZCwgcHJvZHVjdF9uYW1lLCBncm91 cF9pZCkNCkZST00gcHJvZHVjdHMNCk9SREVSIEJZIHByb2R1Y3RfaWQsIHByb2R1Y3RfbmFtZSwg Z3JvdXBfaWQNCg0KVG8gZ2V0IHRoZSBzYW1lIHNlcXVlbmNlIGluIHRoZSBST1dfSUQtcywgYW5k IHRoZSBRdWVyeSByb3dzPw0KDQpCUg0KZGQNCg0KR3VzdGF2c3NvbiBNaWthZWwgPG1pa2FlbC5n dXN0YXZzc29uQHNtaGkuc2U8bWFpbHRvOm1pa2FlbC5ndXN0YXZzc29uQHNtaGkuc2U+PiBlenQg w61ydGEgKGlkxZFwb250OiAyMDIzLiBtw6FyYy4gMTAuLCBQLCA4OjMzKToNCg0KSGksDQoNCg0K SXMgaXQgc29tZXRoaW5nIGxpa2Ugcm93X251bWJlcigpIHlvdSB3YW50Pw0KDQpodHRwczovL3d3 dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzL2N1cnJlbnQvZnVuY3Rpb25zLXdpbmRvdy5odG1sDQoNCktS DQpNaWthZWwNCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fDQpGcsOlbjogRHVydW1k YXJhIDxkdXJ1bWRhcmFAZ21haWwuY29tPG1haWx0bzpkdXJ1bWRhcmFAZ21haWwuY29tPj4NClNr aWNrYXQ6IGRlbiAxMCBtYXJzIDIwMjMgODoxMg0KVGlsbDogUG9zdGdyZXMgR2VuZXJhbA0Kw4Rt bmU6IE9uZmx5LCBmdW5jdGlvbiBnZW5lcmF0ZWQgSUQgZm9yIFNlbGVjdCBRdWVyeQ0KDQpEZWFy IE1lbWJlcnMhDQoNCkknbSBzZWFyY2hpbmcgZm9yIGEgc2ltcGxlIHNvbHV0aW9uLCBsaWtlIHRo aXM6DQoNCnNlbGVjdCBHZXRJREZvclRoaXNTZWxlY3QoMSwgMSkgYXMgVUlELCAqIGZyb20gYW55 dGFibGVoYXNkb3VibGVzdHJpbmdrZXkNCmpvaW4gb3RoZXJ0YWJsZWhhc25vdHVuaXF1ZWludGVn ZXJrZXkgLi4uDQp3aGVyZSAuLi4uDQoNCk9rLCBJIGNhbiBtYWtlIGEgc2VxdWVuY2UsIGJ1dCBJ IGRvbid0IHdhbnQgdG8gdXNlIHBlcnNpc3RlbnQgZGF0YS4NCkl0IGlzIGVub3VnaCB0byBnZXQg MS4uLk4gYXMgVUlEIGZvciB0aGlzIHNlbGVjdC4NCg0KTGlrZSBnZW5lcmF0ZV9zZXJpZXMsIGJ1 dCB0aGF0IGlzIGdlbmVyYXRpbmcgcm93cy4NCg0KTWF5YmUgeW91IGhhdmUgc29tZSB0cmljayB0 byBkbyB0aGlzLg0KDQpUaGFuayB5b3UgZm9yIGFueSBhc3Npc3RhbmNlIQ0KDQpCZXN0IHJlZ2Fy ZHMNCmRkDQo= --_000_5cc66caf91ad4c888f6ffa5cb7b4435csmhise_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWw+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIgY29udGVudD0i dGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjwvaGVhZD4NCjxib2R5Pg0KPHN0eWxlIHR5cGU9 InRleHQvY3NzIiBzdHlsZT0iZGlzcGxheTpub25lOyI+PCEtLSBQIHttYXJnaW4tdG9wOjA7bWFy Z2luLWJvdHRvbTowO30gLS0+PC9zdHlsZT4NCjxkaXYgaWQ9ImRpdnRhZ2RlZmF1bHR3cmFwcGVy IiBzdHlsZT0iZm9udC1zaXplOjEycHQ7Y29sb3I6IzAwMDAwMDtmb250LWZhbWlseTpDYWxpYnJp LEhlbHZldGljYSxzYW5zLXNlcmlmOyIgZGlyPSJsdHIiPg0KPHA+Tm8sIHRoZSByZXN1bHQgd2ls bCBiZSBvcmRlcmVkIGJ5IHRoZSB3aW5kb3cgZnVuY3Rpb25zIG9yZGVyIGNsYXVzZSBzbyBubyBh ZGRpdGlvbmFsIG9yZGVyaW5nIGlzIG5lc3Nlc2FyeS48YnI+DQpZb3UgY2FuIHRyeSB0aGlzIGJ5 IGNoYW5naW5nIGl0IHRvIE9WRVIoT1JERVIgQlkgcHJvZHVjdF9uYW1lKTwvcD4NCjxwPjxicj4N CjwvcD4NCjxwPktSPC9wPg0KPHA+TWlrYWVsPC9wPg0KPC9kaXY+DQo8aHIgc3R5bGU9ImRpc3Bs YXk6aW5saW5lLWJsb2NrO3dpZHRoOjk4JSIgdGFiaW5kZXg9Ii0xIj4NCjxkaXYgaWQ9ImRpdlJw bHlGd2RNc2ciIGRpcj0ibHRyIj48Zm9udCBmYWNlPSJDYWxpYnJpLCBzYW5zLXNlcmlmIiBzdHls ZT0iZm9udC1zaXplOjExcHQiIGNvbG9yPSIjMDAwMDAwIj48Yj5GcsOlbjo8L2I+IER1cnVtZGFy YSAmbHQ7ZHVydW1kYXJhQGdtYWlsLmNvbSZndDs8YnI+DQo8Yj5Ta2lja2F0OjwvYj4gZGVuIDEw IG1hcnMgMjAyMyAwODo0MTowNjxicj4NCjxiPlRpbGw6PC9iPiBHdXN0YXZzc29uIE1pa2FlbDxi cj4NCjxiPktvcGlhOjwvYj4gUG9zdGdyZXMgR2VuZXJhbDxicj4NCjxiPsOEbW5lOjwvYj4gUmU6 IE9uZmx5LCBmdW5jdGlvbiBnZW5lcmF0ZWQgSUQgZm9yIFNlbGVjdCBRdWVyeTwvZm9udD4NCjxk aXY+Jm5ic3A7PC9kaXY+DQo8L2Rpdj4NCjxkaXY+DQo8ZGl2IGRpcj0ibHRyIj4mbmJzcDtEZWFy IE1pa2FlbCENCjxkaXY+PGJyPg0KV29vb29vdy4uLiB0aGF0IGlzIGl0IQ0KPGRpdj5UaGFuayB5 b3UhPC9kaXY+DQo8ZGl2Pjxicj4NCjwvZGl2Pg0KU0VMRUNUIHByb2R1Y3RfaWQsIHByb2R1Y3Rf bmFtZSwgZ3JvdXBfaWQsIFJPV19OVU1CRVIgKCkgT1ZFUiAoT1JERVIgQlkgcHJvZHVjdF9pZCkg RlJPTSBwcm9kdWN0czsNCjxkaXY+PGJyPg0KPC9kaXY+DQo8ZGl2PkRvZXMgdGhpcyBtZWFuIHRo YXQgSSBoYXZlIHRvIGR1cGxpY2F0ZSB0aGUgb3JkZXIgYnkgY2xhdXNlPzwvZGl2Pg0KPGRpdj48 YnI+DQo8L2Rpdj4NCjxkaXY+U0VMRUNUIHByb2R1Y3RfaWQsIHByb2R1Y3RfbmFtZSwgZ3JvdXBf aWQsIFJPV19OVU1CRVIgKCkmbmJzcDs8L2Rpdj4NCjxkaXY+Jm5ic3A7ICZuYnNwOyBPVkVSICg8 Yj5PUkRFUiBCWSBwcm9kdWN0X2lkLCBwcm9kdWN0X25hbWUsIGdyb3VwX2lkPC9iPikmbmJzcDs8 L2Rpdj4NCjxkaXY+RlJPTSBwcm9kdWN0cyZuYnNwOzwvZGl2Pg0KPGRpdj48Yj5PUkRFUiBCWSBw cm9kdWN0X2lkLCBwcm9kdWN0X25hbWUsIGdyb3VwX2lkPC9iPjxicj4NCjwvZGl2Pg0KPGRpdj48 YnI+DQo8L2Rpdj4NCjxkaXY+VG8gZ2V0IHRoZSBzYW1lIHNlcXVlbmNlIGluIHRoZSBST1dfSUQt cywgYW5kIHRoZSBRdWVyeSByb3dzPzwvZGl2Pg0KPGRpdj48YnI+DQo8L2Rpdj4NCjxkaXY+QlI8 L2Rpdj4NCmRkPC9kaXY+DQo8L2Rpdj4NCjxicj4NCjxkaXYgY2xhc3M9ImdtYWlsX3F1b3RlIj4N CjxkaXYgZGlyPSJsdHIiIGNsYXNzPSJnbWFpbF9hdHRyIj5HdXN0YXZzc29uIE1pa2FlbCAmbHQ7 PGEgaHJlZj0ibWFpbHRvOm1pa2FlbC5ndXN0YXZzc29uQHNtaGkuc2UiPm1pa2FlbC5ndXN0YXZz c29uQHNtaGkuc2U8L2E+Jmd0OyBlenQgw61ydGEgKGlkxZFwb250OiAyMDIzLiBtw6FyYy4gMTAu LCBQLCA4OjMzKTo8YnI+DQo8L2Rpdj4NCjxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIg c3R5bGU9Im1hcmdpbjowcHggMHB4IDBweCAwLjhleDtib3JkZXItbGVmdDoxcHggc29saWQgcmdi KDIwNCwyMDQsMjA0KTtwYWRkaW5nLWxlZnQ6MWV4Ij4NCjxkaXYgY2xhc3M9Im1zZzU1MzcxMjI2 NTE3NDYyNDAwMDUiPg0KPGRpdiBkaXI9Imx0ciI+DQo8ZGl2IGlkPSJtXzY4MDI0NjEwNDE0NjA5 NDg4NTZkaXZ0YWdkZWZhdWx0d3JhcHBlciIgc3R5bGU9ImZvbnQtc2l6ZToxMnB0O2NvbG9yOnJn YigwLDAsMCk7Zm9udC1mYW1pbHk6Q2FsaWJyaSxIZWx2ZXRpY2Esc2Fucy1zZXJpZiIgZGlyPSJs dHIiPg0KPGRpdiBpZD0ibV82ODAyNDYxMDQxNDYwOTQ4ODU2ZGl2dGFnZGVmYXVsdHdyYXBwZXIi IHN0eWxlPSJmb250LXNpemU6MTJwdDtjb2xvcjpyZ2IoMCwwLDApO2ZvbnQtZmFtaWx5OkNhbGli cmksSGVsdmV0aWNhLHNhbnMtc2VyaWYsRW1vamlGb250LCZxdW90O0FwcGxlIENvbG9yIEVtb2pp JnF1b3Q7LCZxdW90O1NlZ29lIFVJIEVtb2ppJnF1b3Q7LE5vdG9Db2xvckVtb2ppLCZxdW90O1Nl Z29lIFVJIFN5bWJvbCZxdW90OywmcXVvdDtBbmRyb2lkIEVtb2ppJnF1b3Q7LEVtb2ppU3ltYm9s cyIgZGlyPSJsdHIiPg0KPHA+SGksPC9wPg0KPHA+PGJyPg0KPC9wPg0KPHA+SXMgaXQgc29tZXRo aW5nIGxpa2Ugcm93X251bWJlcigpIHlvdSB3YW50PzwvcD4NCjxhIGhyZWY9Imh0dHBzOi8vd3d3 LnBvc3RncmVzcWwub3JnL2RvY3MvY3VycmVudC9mdW5jdGlvbnMtd2luZG93Lmh0bWwiIHRhcmdl dD0iX2JsYW5rIj5odHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzL2N1cnJlbnQvZnVuY3Rp b25zLXdpbmRvdy5odG1sPC9hPjxicj4NCjxicj4NCktSPC9kaXY+DQo8ZGl2IGlkPSJtXzY4MDI0 NjEwNDE0NjA5NDg4NTZkaXZ0YWdkZWZhdWx0d3JhcHBlciIgc3R5bGU9ImZvbnQtc2l6ZToxMnB0 O2NvbG9yOnJnYigwLDAsMCk7Zm9udC1mYW1pbHk6Q2FsaWJyaSxIZWx2ZXRpY2Esc2Fucy1zZXJp ZixFbW9qaUZvbnQsJnF1b3Q7QXBwbGUgQ29sb3IgRW1vamkmcXVvdDssJnF1b3Q7U2Vnb2UgVUkg RW1vamkmcXVvdDssTm90b0NvbG9yRW1vamksJnF1b3Q7U2Vnb2UgVUkgU3ltYm9sJnF1b3Q7LCZx dW90O0FuZHJvaWQgRW1vamkmcXVvdDssRW1vamlTeW1ib2xzIiBkaXI9Imx0ciI+DQpNaWthZWw8 YnI+DQo8ZGl2IHN0eWxlPSJjb2xvcjpyZ2IoMCwwLDApIj4NCjxociBzdHlsZT0iZGlzcGxheTpp bmxpbmUtYmxvY2s7d2lkdGg6OTglIj4NCjxkaXYgaWQ9Im1fNjgwMjQ2MTA0MTQ2MDk0ODg1NmRp dlJwbHlGd2RNc2ciIGRpcj0ibHRyIj48Zm9udCBmYWNlPSJDYWxpYnJpLCBzYW5zLXNlcmlmIiBj b2xvcj0iIzAwMDAwMCIgc3R5bGU9ImZvbnQtc2l6ZToxMXB0Ij48Yj5GcsOlbjo8L2I+IER1cnVt ZGFyYSAmbHQ7PGEgaHJlZj0ibWFpbHRvOmR1cnVtZGFyYUBnbWFpbC5jb20iIHRhcmdldD0iX2Js YW5rIj5kdXJ1bWRhcmFAZ21haWwuY29tPC9hPiZndDs8YnI+DQo8Yj5Ta2lja2F0OjwvYj4gZGVu IDEwIG1hcnMgMjAyMyA4OjEyPGJyPg0KPGI+VGlsbDo8L2I+IFBvc3RncmVzIEdlbmVyYWw8YnI+ DQo8Yj7DhG1uZTo8L2I+IE9uZmx5LCBmdW5jdGlvbiBnZW5lcmF0ZWQgSUQgZm9yIFNlbGVjdCBR dWVyeTwvZm9udD4NCjxkaXY+Jm5ic3A7PC9kaXY+DQo8L2Rpdj4NCjxkaXY+DQo8ZGl2IGRpcj0i bHRyIj5EZWFyIE1lbWJlcnMhDQo8ZGl2Pjxicj4NCjwvZGl2Pg0KPGRpdj5JJ20gc2VhcmNoaW5n IGZvciBhIHNpbXBsZSBzb2x1dGlvbiwgbGlrZSB0aGlzOjwvZGl2Pg0KPGRpdj48YnI+DQo8L2Rp dj4NCjxkaXY+c2VsZWN0IEdldElERm9yVGhpc1NlbGVjdCgxLCAxKSBhcyBVSUQsICogZnJvbSBh bnl0YWJsZWhhc2RvdWJsZXN0cmluZ2tleTwvZGl2Pg0KPGRpdj5qb2luIG90aGVydGFibGVoYXNu b3R1bmlxdWVpbnRlZ2Vya2V5IC4uLjwvZGl2Pg0KPGRpdj53aGVyZSAuLi4uPC9kaXY+DQo8ZGl2 Pjxicj4NCjwvZGl2Pg0KPGRpdj5PaywgSSBjYW4gbWFrZSBhIHNlcXVlbmNlLCBidXQgSSBkb24n dCB3YW50IHRvIHVzZSBwZXJzaXN0ZW50IGRhdGEuPC9kaXY+DQo8ZGl2Pkl0IGlzIGVub3VnaCB0 byBnZXQgMS4uLk4gYXMgVUlEIGZvciB0aGlzIHNlbGVjdC48L2Rpdj4NCjxkaXY+PGJyPg0KPC9k aXY+DQo8ZGl2Pkxpa2UgZ2VuZXJhdGVfc2VyaWVzLCBidXQgdGhhdCBpcyBnZW5lcmF0aW5nIHJv d3MuPC9kaXY+DQo8ZGl2Pjxicj4NCjwvZGl2Pg0KPGRpdj5NYXliZSB5b3UgaGF2ZSBzb21lIHRy aWNrIHRvIGRvIHRoaXMuPC9kaXY+DQo8ZGl2Pjxicj4NCjwvZGl2Pg0KPGRpdj5UaGFuayB5b3Ug Zm9yIGFueSBhc3Npc3RhbmNlITwvZGl2Pg0KPGRpdj48YnI+DQo8L2Rpdj4NCjxkaXY+QmVzdCBy ZWdhcmRzPC9kaXY+DQo8ZGl2PmRkPC9kaXY+DQo8L2Rpdj4NCjwvZGl2Pg0KPC9kaXY+DQo8L2Rp dj4NCjwvZGl2Pg0KPC9kaXY+DQo8L2Rpdj4NCjwvYmxvY2txdW90ZT4NCjwvZGl2Pg0KPC9kaXY+ DQo8L2JvZHk+DQo8L2h0bWw+DQo= --_000_5cc66caf91ad4c888f6ffa5cb7b4435csmhise_--