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.96) (envelope-from ) id 1wAl3X-000IQN-0H for pgsql-docs@arkaria.postgresql.org; Thu, 09 Apr 2026 08:48:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wAl3U-004dRi-3C for pgsql-docs@arkaria.postgresql.org; Thu, 09 Apr 2026 08:48:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w9z2c-00Eb4R-0a for pgsql-docs@lists.postgresql.org; Tue, 07 Apr 2026 05:31:58 +0000 Received: from mail-dy1-x1341.google.com ([2607:f8b0:4864:20::1341]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w9z2a-000000012LU-1Bx6 for pgsql-docs@lists.postgresql.org; Tue, 07 Apr 2026 05:31:58 +0000 Received: by mail-dy1-x1341.google.com with SMTP id 5a478bee46e88-2ce22328930so3860117eec.0 for ; Mon, 06 Apr 2026 22:31:55 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775539913; cv=none; d=google.com; s=arc-20240605; b=dS3F74ofb1WOBuQtgrFrP9QVBNrHlbHiQRnUg/S9Ser/GqI8HXuFpFtyshusgEWdH2 x77wSfsdwoI2ExAMEoMn76BxupmLx4ifyxG6HgzJAyN5W61tCesPEcjUcwgTvBdM24Z2 MA5taZ9uE49OtQrAnB5gC2yfxT0tcXrV8bylt4Q6/e+WHqTYZgK7vfkOBDBMu3DzEbi7 TGQuEczSFZ21lHD92F1RFuaq17hiUznu0e/vN7OIMm4J6Kt7MNP0WRL+xElm2sVadqUs kY2SjkWk5nvZot3WIHSKQ7cSjbbXjIUB77X6NRm8Hj4nh71ciutoecuI0qh97MGk/+3I SX/g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=3tVkUwf2AjIptNOX9VJ3Vpi0PJd6sxHf8chR2Xt8Et0=; fh=eitnFYqiGz5Qd9tP4ETN4LQj8BMqIm+FgmdzoPwQKYs=; b=Db6+Up3JA5nQWv8gllbCt6FpXTYlfhCms8c676SXOUse/uX0MyN8w7TEB4s00PXrjq ncC+iZqLH4YfLnEjCX8RrFb+UZq4w2XVn5Rz+bKtMb6j15KGsGF1QfGktnND/G+o3m5S q50ktwXTyZy1oM+x2xKEKx3Sj6wGPFP7V75c4GYzNFXyqkcH0ZvusWNAZvF3h4SiwYuk wzAjPJcWp+vPzz9redGFMHL2QnC1AtiSwBz8suR5IMJwJ5XeAT+blhLOF2WYb4cjldA4 V0MOVlfP7X2TYsuJW6JNBqZbnE4I6RpemYi6MtM2qdCIrYptP4AYZoz1mSNXS3N643xP ioBQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775539913; x=1776144713; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=3tVkUwf2AjIptNOX9VJ3Vpi0PJd6sxHf8chR2Xt8Et0=; b=VU+Rv4/inx4i8eaJO4xfOfcFSGyEMuvizxDeM2qAfb85BVSR0V1IXvl2i36nxwyo+C qDf6ZNHKb+2ua73U87W+YX0JOOv6atDD0lfbGuVKRJTi3LVflyEZ+Y6liMq7gWAce+E3 Z08rruaIBIQvLOs0aESHKGgDSzsYtK5QP3o75rWMw/VDIl6DTxlppeoPQ2ZQe7EKY2Hi UZZttvMWMelUrLFXXQWVgyMnnL1K8YA9P0vv8/fHM+suKE4+KNPRbMmHOH0rNArvb1YH mwXa18tNuiKIRzaBL9jnbrajItxGcX+5zlk0puNtPA50cL9Q9jXAaJWcnEnWvcCTncSF DtEA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775539913; x=1776144713; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=3tVkUwf2AjIptNOX9VJ3Vpi0PJd6sxHf8chR2Xt8Et0=; b=YPc1QDmKVB4jMBdTBUeVnbfGu2sGFelrDdH+0EzoaBdt2ZpTRs9+uH1bt2ga3hpGLk 0F/iT54u9ua6002nOppu3pTgmiALKbK8wmfJDs5zNS1md3HfTEcjPisTjHoBO/TEBy2A A2OiezCsx3rr1USDBt6ntbtOmwc0YujsOwcvp2vUrwahzr3vwHRCKSBLbDdtKtGdX4TQ v/JNPE2HlUUDh62FxPEmp4EUfA46Tj2JksicZU5He7m04fmQna7zTotodSKJP+O1/sBt Vra08PANVPOscSyiyjnVieRXcN1mHAOs8ZqyOLqofTKXoyhIo3lH4I+XTf72TQgevjgR 4w3g== X-Gm-Message-State: AOJu0YzFZlzSGJzStDfPmxej+qg2DLYXkMUjiYvNeKcA1zS7MhxZt0WD nvtIY9B3SWgQ8yS/hR18a4R6+uFMlmAobHc/t2ROchRI6PzHsxYjQn2BvxS7mnMrB2LFDgzntDj SWbI0bsPnkHtDN/VgjjExvkgBY84dWlnBzIioY7xSqMPu X-Gm-Gg: AeBDieuzMM9DFg1JgCNycnPMgTPjD/L3fnH9B2e/sadzs7zGrJRKnvYSiHmpu5RLJpb v3i0HWoKKEc8NH8E23IPSAdiqXY2Nom8SY6htPErttDCpGd9BbjktUKroMLtxOot7b6vgNVZzTF eqnhT0tlHlbkUQ8o9a5MwhehDlk91ollXcYcYLDmpAFuSQ0ZLIVopMiZ56vpm0oEGULnFAWT13b ntU9cN/EzLfis3cJISqoQxSy/JkoAOPMoJRXwKQ1dG7BLP8A0TP0tlHoNTLGMvG3xIZNkTW6aHk 2je/e1eu X-Received: by 2002:a05:7300:2315:b0:2c4:59a6:9e5 with SMTP id 5a478bee46e88-2cbf9ee8dc0mr7671440eec.12.1775539913347; Mon, 06 Apr 2026 22:31:53 -0700 (PDT) MIME-Version: 1.0 From: Dapeng Wang Date: Tue, 7 Apr 2026 13:31:40 +0800 X-Gm-Features: AQROBzB6ASR-AUaPiLF7phmD5Kzgozng_koXU32unyGM4bUYRJ1M7Hv-0AToSCo Message-ID: Subject: doc: add examples section to earthdistance documentation To: pgsql-docs@lists.postgresql.org Content-Type: multipart/mixed; boundary="000000000000d2504f064ed8195a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d2504f064ed8195a Content-Type: multipart/alternative; boundary="000000000000d2504e064ed81958" --000000000000d2504e064ed81958 Content-Type: text/plain; charset="UTF-8" Hi, I noticed that the earthdistance documentation has no usage examples, which makes it harder for new users to get started with the module. Other contrib modules like hstore already include helpful examples. I've attached a patch that adds an Examples section covering the main functions and the point-based distance operator. All examples were tested on PostgreSQL 18.3. Regards, Dapeng Wang --000000000000d2504e064ed81958 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

I noticed that the earthdistance documentation = has no usage
examples, which makes it harder for new users to get starte= d
with the module. Other contrib modules like hstore already
include = helpful examples.

I've attached a patch that adds an Examples se= ction covering
the main functions and the point-based distance operator.=
All examples were tested on PostgreSQL 18.3.

Regards,
Dapeng = Wang
--000000000000d2504e064ed81958-- --000000000000d2504f064ed8195a Content-Type: application/octet-stream; name="0001-doc-add-examples-section-to-earthdistance-documentat.patch" Content-Disposition: attachment; filename="0001-doc-add-examples-section-to-earthdistance-documentat.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mno6lkp00 RnJvbSBhOTE5NDIxMGEyNGE3ODVjMTVhZmNhZDI1NDNmZmMxNzQzMjA1ODlkIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiB3YW5nZGFwZW5nIDwzNDU3MzE5MjNAcXEuY29tPgpEYXRlOiBU dWUsIDcgQXByIDIwMjYgMTM6MTY6NTQgKzA4MDAKU3ViamVjdDogW1BBVENIXSBkb2M6IGFkZCBl eGFtcGxlcyBzZWN0aW9uIHRvIGVhcnRoZGlzdGFuY2UgZG9jdW1lbnRhdGlvbgoKLS0tCiBkb2Mv c3JjL3NnbWwvZWFydGhkaXN0YW5jZS5zZ21sIHwgMTAzICsrKysrKysrKysrKysrKysrKysrKysr KysrKysrKysrCiAxIGZpbGUgY2hhbmdlZCwgMTAzIGluc2VydGlvbnMoKykKCmRpZmYgLS1naXQg YS9kb2Mvc3JjL3NnbWwvZWFydGhkaXN0YW5jZS5zZ21sIGIvZG9jL3NyYy9zZ21sL2VhcnRoZGlz dGFuY2Uuc2dtbAppbmRleCA1YTcwOWUzLi44OWU2MDU5IDEwMDY0NAotLS0gYS9kb2Mvc3JjL3Nn bWwvZWFydGhkaXN0YW5jZS5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9lYXJ0aGRpc3RhbmNlLnNn bWwKQEAgLTI2Miw0ICsyNjIsMTA3IEBACiAKICA8L3NlY3QyPgogCisgPHNlY3QyIGlkPSJlYXJ0 aGRpc3RhbmNlLWV4YW1wbGVzIj4KKyAgPHRpdGxlPkV4YW1wbGVzPC90aXRsZT4KKworICA8cGFy YT4KKyAgIFRoZSBmb2xsb3dpbmcgZXhhbXBsZXMgZGVtb25zdHJhdGUgdGhlIHVzZSBvZiB0aGUK KyAgIDxmaWxlbmFtZT5lYXJ0aGRpc3RhbmNlPC9maWxlbmFtZT4gbW9kdWxlIHdpdGggbG9jYXRp b25zIGluCisgICBUb2t5byAobGF0aXR1ZGUgMzUuNjc2MiwgbG9uZ2l0dWRlIDEzOS42NTAzKSBh bmQKKyAgIE9zYWthIChsYXRpdHVkZSAzNC42OTM3LCBsb25naXR1ZGUgMTM1LjUwMjMpLgorICA8 L3BhcmE+CisKKyAgPHBhcmE+CisgICBGaXJzdCwgaW5zdGFsbCB0aGUgcmVxdWlyZWQgZXh0ZW5z aW9uczoKKzxwcm9ncmFtbGlzdGluZz4KK0NSRUFURSBFWFRFTlNJT04gY3ViZTsKK0NSRUFURSBF WFRFTlNJT04gZWFydGhkaXN0YW5jZSBDQVNDQURFOworPC9wcm9ncmFtbGlzdGluZz4KKyAgPC9w YXJhPgorCisgIDxwYXJhPgorICAgUmV0cmlldmUgdGhlIGFzc3VtZWQgcmFkaXVzIG9mIHRoZSBF YXJ0aCBpbiBtZXRlcnM6Cis8cHJvZ3JhbWxpc3Rpbmc+CitTRUxFQ1QgZWFydGgoKTsKKyAgZWFy dGgKKy0tLS0tLS0tLQorIDYzNzgxNjgKKygxIHJvdykKKzwvcHJvZ3JhbWxpc3Rpbmc+CisgIDwv cGFyYT4KKworICA8cGFyYT4KKyAgIENvbnZlcnQgbGF0aXR1ZGUgYW5kIGxvbmdpdHVkZSB0byBh biA8dHlwZT5lYXJ0aDwvdHlwZT4gcG9pbnQKKyAgIChhIDNEIGNvb3JkaW5hdGUpOgorPHByb2dy YW1saXN0aW5nPgorU0VMRUNUIGxsX3RvX2VhcnRoKDM1LjY3NjIsIDEzOS42NTAzKTsKKyAgICAg ICAgICAgICAgICAgICAgICAgICBsbF90b19lYXJ0aAorLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQorICgtMzk0ODU5MS4yNTc0OTIz MjI1LCAzMzU0NTQxLjc0MTM4NDcyOSwgMzcxOTc3Mi4wMTIyMDU0MTIpCisoMSByb3cpCis8L3By b2dyYW1saXN0aW5nPgorICA8L3BhcmE+CisKKyAgPHBhcmE+CisgICBDYWxjdWxhdGUgdGhlIGdy ZWF0IGNpcmNsZSBkaXN0YW5jZSBpbiBtZXRlcnMgYmV0d2VlbiBUb2t5byBhbmQgT3Nha2E6Cis8 cHJvZ3JhbWxpc3Rpbmc+CitTRUxFQ1QgZWFydGhfZGlzdGFuY2UoCisgIGxsX3RvX2VhcnRoKDM1 LjY3NjIsIDEzOS42NTAzKSwKKyAgbGxfdG9fZWFydGgoMzQuNjkzNywgMTM1LjUwMjMpCispOwor ICBlYXJ0aF9kaXN0YW5jZQorLS0tLS0tLS0tLS0tLS0tLS0tLQorIDM5Mjg4Mi43NjQ4MzQwNzQz CisoMSByb3cpCis8L3Byb2dyYW1saXN0aW5nPgorICA8L3BhcmE+CisKKyAgPHBhcmE+CisgICBF eHRyYWN0IGxhdGl0dWRlIGFuZCBsb25naXR1ZGUgYmFjayBmcm9tIGFuIDx0eXBlPmVhcnRoPC90 eXBlPiBwb2ludDoKKzxwcm9ncmFtbGlzdGluZz4KK1NFTEVDVCBsYXRpdHVkZShsbF90b19lYXJ0 aCgzNS42NzYyLCAxMzkuNjUwMykpOworICAgICAgbGF0aXR1ZGUKKy0tLS0tLS0tLS0tLS0tLS0t LS0tCisgMzUuNjc2MTk5OTk5OTk5OTk0CisoMSByb3cpCisKK1NFTEVDVCBsb25naXR1ZGUobGxf dG9fZWFydGgoMzUuNjc2MiwgMTM5LjY1MDMpKTsKKyBsb25naXR1ZGUKKy0tLS0tLS0tLS0tCisg IDEzOS42NTAzCisoMSByb3cpCis8L3Byb2dyYW1saXN0aW5nPgorICA8L3BhcmE+CisKKyAgPHBh cmE+CisgICBVc2luZyB0aGUgcG9pbnQtYmFzZWQgb3BlcmF0b3IgdG8gY2FsY3VsYXRlIGRpc3Rh bmNlIGluIHN0YXR1dGUgbWlsZXM6Cis8cHJvZ3JhbWxpc3Rpbmc+CitTRUxFQ1QgcG9pbnQoMTM5 LjY1MDMsIDM1LjY3NjIpICZsdDtAJmd0OyBwb2ludCgxMzUuNTAyMywgMzQuNjkzNyk7CisgICAg ID9jb2x1bW4/CistLS0tLS0tLS0tLS0tLS0tLS0tCisgMjQzLjg1MTE3MjkyOTY5NjcKKygxIHJv dykKKzwvcHJvZ3JhbWxpc3Rpbmc+CisgICBOb3RlIHRoYXQgPHR5cGU+cG9pbnQ8L3R5cGU+IHRh a2VzIChsb25naXR1ZGUsIGxhdGl0dWRlKSBvcmRlciwKKyAgIG5vdCAobGF0aXR1ZGUsIGxvbmdp dHVkZSkuCisgIDwvcGFyYT4KKworICA8cGFyYT4KKyAgIFVzZSA8ZnVuY3Rpb24+ZWFydGhfYm94 PC9mdW5jdGlvbj4gdG8gZmluZCBwb2ludHMgd2l0aGluIDUwIGttIG9mCisgICBUb2t5by4gIFRo aXMgY3JlYXRlcyBhIGJvdW5kaW5nIGJveCBzdWl0YWJsZSBmb3IgYW4gaW5kZXhlZCBzZWFyY2g6 Cis8cHJvZ3JhbWxpc3Rpbmc+CitTRUxFQ1QgZWFydGhfYm94KGxsX3RvX2VhcnRoKDM1LjY3NjIs IDEzOS42NTAzKSwgNTAwMDApOworPC9wcm9ncmFtbGlzdGluZz4KKyAgIFNpbmNlIHNvbWUgcG9p bnRzIGluc2lkZSB0aGUgYm94IG1heSBiZSBmYXJ0aGVyIHRoYW4gNTAga20sCisgICBjb21iaW5l IGl0IHdpdGggPGZ1bmN0aW9uPmVhcnRoX2Rpc3RhbmNlPC9mdW5jdGlvbj4gZm9yIGV4YWN0IGZp bHRlcmluZzoKKzxwcm9ncmFtbGlzdGluZz4KK1NFTEVDVCBuYW1lLCBsb2NhdGlvbgorRlJPTSBj aXRpZXMKK1dIRVJFIGVhcnRoX2JveChsbF90b19lYXJ0aCgzNS42NzYyLCAxMzkuNjUwMyksIDUw MDAwKSBAJmd0OyBsb2NhdGlvbgorICBBTkQgZWFydGhfZGlzdGFuY2UobG9jYXRpb24sIGxsX3Rv X2VhcnRoKDM1LjY3NjIsIDEzOS42NTAzKSkgJmx0OyA1MDAwMDsKKzwvcHJvZ3JhbWxpc3Rpbmc+ CisgIDwvcGFyYT4KKworIDwvc2VjdDI+CisgCiA8L3NlY3QxPgotLSAKMi40Ni4yLndpbmRvd3Mu MQoK --000000000000d2504f064ed8195a--