Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tMZNd-0053Fn-D8 for pgsql-committers@arkaria.postgresql.org; Sat, 14 Dec 2024 21:08:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tMZMb-006mwW-29 for pgsql-committers@arkaria.postgresql.org; Sat, 14 Dec 2024 21:07:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tMZMa-006mwF-Pq for pgsql-committers@lists.postgresql.org; Sat, 14 Dec 2024 21:07:50 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tMZMY-002qUI-8U for pgsql-committers@lists.postgresql.org; Sat, 14 Dec 2024 21:07:48 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tMZMX-008pND-3X for pgsql-committers@lists.postgresql.org; Sat, 14 Dec 2024 21:07:45 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tMZMV-002jZf-3a for pgsql-committers@lists.postgresql.org; Sat, 14 Dec 2024 21:07:43 +0000 Content-Type: multipart/mixed; boundary="===============0360085352095495512==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: contrib/earthdistance: Use SQL-standard function bodies. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 14 Dec 2024 21:07:43 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0360085352095495512== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Y29udHJpYi9lYXJ0aGRpc3RhbmNlOiBVc2UgU1FMLXN0YW5kYXJkIGZ1bmN0aW9uIGJvZGllcy4K ClRoZSBAZXh0c2NoZW1hOm5hbWVAIGZlYXR1cmUgYWRkZWQgYnkgNzJhNWIxZmM4IGFsbG93cyB1 cyB0bwptYWtlIGVhcnRoZGlzdGFuY2UncyByZWZlcmVuY2VzIHRvIHRoZSBjdWJlIGV4dGVuc2lv biBmdWxseQpzZWFyY2gtcGF0aC1zZWN1cmUsIHNvIGxvbmcgYXMgYWxsIHRob3NlIHJlZmVyZW5j ZXMgYXJlCnJlc29sdmVkIGF0IGV4dGVuc2lvbiBpbnN0YWxsYXRpb24gdGltZSBub3QgcnVudGlt ZS4KVG8gZG8gdGhhdCwgd2UgbXVzdCBjb252ZXJ0IGVhcnRoZGlzdGFuY2UncyBTUUwgZnVuY3Rp b25zIHRvCnRoZSBuZXcgU1FMLXN0YW5kYXJkIHN0eWxlOyBidXQgd2Ugd2FudGVkIHRvIGRvIHRo YXQgYW55d2F5LgoKVGhlIGZ1bmN0aW9ucyBjYW4gYmUgdXBkYXRlZCBpbiBvdXIgY3VzdG9tYXJ5 IHN0eWxlIGJ5IHJ1bm5pbmcKQ1JFQVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04gaW4gYW4gZXh0ZW5z aW9uIHVwZGF0ZSBzY3JpcHQuCkhvd2V2ZXIsIHRoZXJlJ3Mgc3RpbGwgcHJvYmxlbXMgaW4gdGhl ICJDUkVBVEUgRE9NQUlOIGVhcnRoIgpjb21tYW5kOiBpdHMgcmVmZXJlbmNlcyB0byBjdWJlIGZ1 bmN0aW9ucyBjb3VsZCBiZSBjYXB0dXJlZApieSBob3N0aWxlIG9iamVjdHMgaW4gZWFydGhkaXN0 YW5jZSdzIGluc3RhbGxhdGlvbiBzY2hlbWEsCmlmIHRoYXQncyBub3Qgd2hlcmUgdGhlIGN1YmUg ZXh0ZW5zaW9uIGlzLiAgV29yc2UsIHRoZSByZWZlcmVuY2UKdG8gdGhlIGN1YmUgdHlwZSBpdHNl bGYgYXMgdGhlIGRvbWFpbidzIGJhc2UgY291bGQgYmUgY2FwdHVyZWQsCmFuZCB0aGF0J3Mgbm90 IHNvbWV0aGluZyB3ZSBjb3VsZCBmaXggYWZ0ZXItdGhlLWZhY3QgaW4gdGhlCnVwZGF0ZSBzY3Jp cHQuCgpXaGF0IEkndmUgZG9uZSBhYm91dCB0aGF0IGlzIHRvIGNoYW5nZSB0aGUgIkNSRUFURSBE T01BSU4gZWFydGgiCmNvbW1hbmQgaW4gdGhlIGJhc2Ugc2NyaXB0IGVhcnRoZGlzdGFuY2UtLTEu MS5zcWwuICBPcmRpbmFyaWx5LApjaGFuZ2luZyBhIHJlbGVhc2VkIGV4dGVuc2lvbiBzY3JpcHQg aXMgZm9yYmlkZGVuOyBidXQgSSB0aGluawppdCdzIG9rYXkgaGVyZSBzaW5jZSB0aGUgcmVzdWx0 cyBvZiBzdWNjZXNzZnVsIChub24tdHJvamFuZWQpCnNjcmlwdCBleGVjdXRpb24gd2lsbCBiZSBp ZGVudGljYWwgdG8gYmVmb3JlLgoKQSBnb29kIGRlYWwgb2YgY2FyZSBpcyBzdGlsbCBuZWVkZWQg dG8gbWFrZSB0aGUgZXh0ZW5zaW9uJ3Mgc2NyaXB0cwpwcm9vZiBhZ2FpbnN0IHNlYXJjaC1wYXRo LWJhc2VkIGF0dGFja3MuICBXZSBoYXZlIHRvIG1ha2Ugc3VyZSB0aGF0CmFsbCB0aGUgZnVuY3Rp b24gYW5kIG9wZXJhdG9yIGludm9jYXRpb25zIGhhdmUgZXhhY3QgYXJndW1lbnQtdHlwZQptYXRj aGVzLCB0byBmb3Jlc3RhbGwgYXR0YWNrcyBiYXNlZCBvbiBzdXBwbHlpbmcgYSBiZXR0ZXIgbWF0 Y2guCkZvcnR1bmF0ZWx5IGVhcnRoZGlzdGFuY2UgaXNuJ3QgdmVyeSBiaWcsIHNvIEkndmUganVz dCBnb25lIHRocm91Z2gKaXQgYW5kIGluc3BlY3RlZCBlYWNoIGNhbGwgdG8gYmUgc3VyZSBvZiB0 aGF0LiAgVGhlIG9ubHkgYWN0dWFsIGNvZGUKY2hhbmdlcyBuZWVkZWQgd2VyZSB0byBzcGVsbCBh bGwgZmxvYXRpbmctcG9pbnQgY29uc3RhbnRzIGluIHRoZSBzdHlsZQonLTEnOjpmbG9hdDgsIHJh dGhlciB0aGFuIGRlcGVuZGluZyBvbiBydW50aW1lIHR5cGUgY29udmVyc2lvbnMgYW5kL29yCm5l Z2F0aW9ucy4gIChJJ20gbm90IHN1cmUgdGhhdCB0aGUgc2hvcnRjdXRzIHByZXZpb3VzbHkgdXNl ZCB3ZXJlCmF0dGFja2FibGUsIGJ1dCByZW1vdmluZyBydW4tdGltZSBlZmZvcnQgaXMgYSBnb29k IHRoaW5nIGFueXdheS4pCgpJIGJlbGlldmUgdGhhdCB0aGlzIGZpeGVzIGVhcnRoZGlzdGFuY2Ug ZW5vdWdoIHRoYXQgd2UgY291bGQKbWFyayBpdCB0cnVzdGVkIGFuZCByZW1vdmUgdGhlIHdhcm5p bmdzIGFib3V0IGl0IHRoYXQgd2VyZQphZGRlZCBieSA3ZWViMWQ5ODY7IGJ1dCBJJ3ZlIG5vdCBk b25lIHRoYXQgaGVyZS4KClRoZSBwcmltYXJ5IHJlYXNvbiBmb3IgZGVhbGluZyB3aXRoIHRoaXMg bm93IGlzIHRoYXQgd2UndmUKcmVjZWl2ZWQgcmVwb3J0cyBvZiBwZ191cGdyYWRlIGZhaWxpbmcg Zm9yIGRhdGFiYXNlcyB0aGF0IHVzZQplYXJ0aGRpc3RhbmNlIGZ1bmN0aW9ucyBpbiBjb250ZXh0 cyBsaWtlIGdlbmVyYXRlZCBjb2x1bW5zLgpUaGF0J3MgYSBjb25zZXF1ZW5jZSBvZiAyYWYwN2Uy ZjcgaGF2aW5nIHJlc3RyaWN0ZWQgdGhlIHNlYXJjaF9wYXRoCnVzZWQgd2hpbGUgZXZhbHVhdGlu ZyBzdWNoIGV4cHJlc3Npb25zLiAgVGhlIG9ubHkgd2F5IHRvIGZpeCB0aGF0CmlzIHRvIG1ha2Ug dGhlIGVhcnRoZGlzdGFuY2UgZnVuY3Rpb25zIGluZGVwZW5kZW50IG9mIHJ1bi10aW1lCnNlYXJj aF9wYXRoLiAgVGhpcyBwYXRjaCBpcyB2ZXJ5IG11Y2ggbmljZXIgdGhhbiB0aGUgYWx0ZXJuYXRp dmUgb2YKYXR0YWNoaW5nICJTRVQgc2VhcmNoX3BhdGgiIGNsYXVzZXMgdG8gZWFydGhkaXN0YW5j ZSdzIGZ1bmN0aW9uczoKaXQgaXMgbW9yZSBzZWN1cmUgYW5kIGRvZXNuJ3QgY3JlYXRlIGEgcnVu LXRpbWUgcGVuYWx0eS4gIFRoZXJlZm9yZSwKSSd2ZSBjaG9zZW4gdG8gYmFjay1wYXRjaCB0aGlz IHRvIHYxNiB3aGVyZSBAZXh0c2NoZW1hOm5hbWVACndhcyBhZGRlZC4gIEl0IHdvbid0IGhlbHAg dW5sZXNzIHVzZXJzIHVwZGF0ZSB0byAxNi43IGFuZCBpc3N1ZQoiQUxURVIgRVhURU5TSU9OIGVh cnRoZGlzdGFuY2UgVVBEQVRFIiBiZWZvcmUgdXBncmFkaW5nIHRvIDE3LApidXQgYXQgbGVhc3Qg dGhlcmUncyBub3cgYSB3YXkgdG8gZGVhbCB3aXRoIHRoZSBwcm9ibGVtIHdpdGhvdXQKbWFudWFs IGludGVydmVudGlvbiBpbiB0aGUgZHVtcC9yZXN0b3JlIHByb2Nlc3MuCgpUb20gTGFuZSBhbmQg Um9uYW4gRHVua2xhdQoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8zMzE2NTY0LmFl TkpGWUVMNThAYWl2ZW5sYXB0b3AKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS82YTY0 MzlmMS04MDM5LTQ0ZTItOGZiOS01OTAyOGY3ZjIwMTRAbWFpbGJveC5vcmcKCkJyYW5jaAotLS0t LS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcv Y29tbWl0ZGlmZi85NjliYmQwZmFmYzBmNGQ5ZWY1MDRjYTk4YTEyN2M4ZDk0NWY3MWEwCgpNb2Rp ZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpjb250cmliL2VhcnRoZGlzdGFuY2UvTWFrZWZpbGUg ICAgICAgICAgICAgICAgICAgIHwgIDMgKy0KY29udHJpYi9lYXJ0aGRpc3RhbmNlL2VhcnRoZGlz dGFuY2UtLTEuMS0tMS4yLnNxbCB8IDczICsrKysrKysrKysrKysrKysrKysrKysrCmNvbnRyaWIv ZWFydGhkaXN0YW5jZS9lYXJ0aGRpc3RhbmNlLS0xLjEuc3FsICAgICAgfCAgOCArLS0KY29udHJp Yi9lYXJ0aGRpc3RhbmNlL2VhcnRoZGlzdGFuY2UuY29udHJvbCAgICAgICB8ICAyICstCmNvbnRy aWIvZWFydGhkaXN0YW5jZS9tZXNvbi5idWlsZCAgICAgICAgICAgICAgICAgfCAgMSArCjUgZmls ZXMgY2hhbmdlZCwgODEgaW5zZXJ0aW9ucygrKSwgNiBkZWxldGlvbnMoLSkKCg== --===============0360085352095495512==--