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 1tMZPc-0053Pt-Ss for pgsql-committers@arkaria.postgresql.org; Sat, 14 Dec 2024 21:10:56 +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 1tMZPa-006pR1-HB for pgsql-committers@arkaria.postgresql.org; Sat, 14 Dec 2024 21:10:55 +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 1tMZMb-006mwQ-QX for pgsql-committers@lists.postgresql.org; Sat, 14 Dec 2024 21:07:51 +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-002qUJ-7d for pgsql-committers@lists.postgresql.org; Sat, 14 Dec 2024 21:07:49 +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-008pNE-3U 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-002jZg-4M for pgsql-committers@lists.postgresql.org; Sat, 14 Dec 2024 21:07:43 +0000 Content-Type: multipart/mixed; boundary="===============0801405764085436989==" 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 --===============0801405764085436989== 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 LS0KUkVMXzE3X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwu b3JnL3BnL2NvbW1pdGRpZmYvMzY1MmRlMzZlNDMyM2U5YmQ1MjgwMTFiMTgxZWU0NjI1MmM0Y2U1 OAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KY29udHJpYi9lYXJ0aGRpc3RhbmNlL01h a2VmaWxlICAgICAgICAgICAgICAgICAgICB8ICAzICstCmNvbnRyaWIvZWFydGhkaXN0YW5jZS9l YXJ0aGRpc3RhbmNlLS0xLjEtLTEuMi5zcWwgfCA3MyArKysrKysrKysrKysrKysrKysrKysrKwpj b250cmliL2VhcnRoZGlzdGFuY2UvZWFydGhkaXN0YW5jZS0tMS4xLnNxbCAgICAgIHwgIDggKy0t CmNvbnRyaWIvZWFydGhkaXN0YW5jZS9lYXJ0aGRpc3RhbmNlLmNvbnRyb2wgICAgICAgfCAgMiAr LQpjb250cmliL2VhcnRoZGlzdGFuY2UvbWVzb24uYnVpbGQgICAgICAgICAgICAgICAgIHwgIDEg Kwo1IGZpbGVzIGNoYW5nZWQsIDgxIGluc2VydGlvbnMoKyksIDYgZGVsZXRpb25zKC0pCgo= --===============0801405764085436989==--