[postgis-tickets] [SCM] postgis.net branch hugo updated. 1fd96379043d6ad26bf01769a5c3b0a7e7dffb03

git at osgeo.org git at osgeo.org
Tue Mar 8 06:01:15 PST 2022


This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "postgis.net".

The branch, hugo has been updated
       via  1fd96379043d6ad26bf01769a5c3b0a7e7dffb03 (commit)
      from  ba0675237b80f568c0ce36cf83ff8bfe49f349c7 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 1fd96379043d6ad26bf01769a5c3b0a7e7dffb03
Author: Regina Obe <lr at pcorp.us>
Date:   Tue Mar 8 09:01:11 2022 -0500

    Move hello world down

diff --git a/content/_index.md b/content/_index.md
index 66c9e22..1f2cd9f 100644
--- a/content/_index.md
+++ b/content/_index.md
@@ -12,32 +12,12 @@ toc: false
 <span itemprop="about">
 <span itemprop="name">PostGIS</span> is a  <span itemprop="applicationSubCategory">spatial</span> <span itemprop="applicationCategory">database</span> extender for [<span itemprop="requirements">PostgreSQL</span>][1] object-relational database.  It adds support for geographic objects allowing location queries to be run in SQL. </span>
 
-```postgres
-WITH city AS (
-  SELECT 'Gotham' AS name,
-	ST_Buffer(ST_Point(0,0), 10) AS geom
-)
- , superhero(name,geom) AS (
-    VALUES
-      ('Bat Boy', ST_Point(0.1,0))
-    , ('Bat Girl', ST_Point(1,1) )
-)
-SELECT superhero.name
-FROM city INNER JOIN superhero
-	ON ST_Contains(city.geom, superhero.geom);
-```
-
-
 [Docs for latest stable release](/docs/)
 
 In addition to basic location awareness, PostGIS offers many features rarely found in other competing spatial databases
 such as Oracle Locator/Spatial and SQL Server. Refer to [PostGIS Feature List](/features/) for more details.
-</span>
 
-## Should you upgrade now?
-
-Not sure if you are running the best possible PostGIS for your PostgreSQL?
-Refer to our [Version compatibility and EOL Policy](/eol_policy/).
+</span>
 
 ## License
 <span>
@@ -47,5 +27,28 @@ target="_blank">GPLv2</a> or later).
 Refer to <a href="/docs/manual-dev/PostGIS_FAQ.html#license_faq" target="_blank">License FAQ</a> for more information.
 PostGIS is developed by a group of contributors led by a Project Steering Committee. </span>
 
+## Should you upgrade now?
+
+Not sure if you are running the best possible PostGIS for your PostgreSQL?
+Refer to our [Version compatibility and EOL Policy](/eol_policy/).
+
+
+## Hello PostGIS
+Here is a sample spatial query to try out in your PostGIS enabled database:
+
+```postgres
+WITH city AS (
+  SELECT 'Gotham' AS name,
+	ST_Buffer(ST_Point(0,0), 10) AS geom
+)
+ , superhero(name,geom) AS (
+    VALUES
+      ('Bat Boy', ST_Point(0.1,0))
+    , ('Bat Girl', ST_Point(1,1) )
+)
+SELECT superhero.name
+FROM city INNER JOIN superhero
+	ON ST_Contains(city.geom, superhero.geom);
+```
 
 [1]: https://postgresql.org

-----------------------------------------------------------------------

Summary of changes:
 content/_index.md | 45 ++++++++++++++++++++++++---------------------
 1 file changed, 24 insertions(+), 21 deletions(-)


hooks/post-receive
-- 
postgis.net


More information about the postgis-tickets mailing list