pg_sphere--1.3.0--1.3.1.sql\

pg_sphere--1.3.1--1.4.0.sql\

pg_sphere--1.4.0--1.4.1.sql\

pg_sphere--1.4.1--1.4.2.sql

pg_sphere--1.4.1--1.4.2.sql\

pg_sphere--1.4.2--1.5.0.sql

DOCS = README.pg_sphere COPYRIGHT.pg_sphere

TESTS = version tables points euler circle line ellipse poly path box\

pg_sphere--1.4.0--1.4.1.sqlpg_sphere--1.4.1--1.4.2.sql:

@echo"-- Nothing to upgrade in the schema">$@

pg_sphere--1.4.2--1.5.0.sql:

cat upgrade_scripts/$@.in$^>$@

src/sscan.o : src/sparse.c

EXTENSION := pg_sphere

PGSPHERE_VERSION := 1.4.2

PGSPHERE_VERSION := 1.5.0

</listitem>

</itemizedlist>

<para>

GiST index can beusedalso forfast finding points closest to the given one

when ordering by an expression with the <literal>&lt;-&gt;</literal> operator

is used,as shown in an example below.

AGiST index can be alsousedforquickly findingthepoints closest to the given one

when ordering by an expression with the <literal>&lt;-&gt;</literal> operator,

as shown in an example below.

</para>

<para>

BRIN indexing supports just spherical points (<type>spoint</type>)

<![CDATA[VACUUM ANALYZE test;]]>

</programlisting>

<para>

To find points closest to a given spherical position, use the <literal>&lt;-&gt;</literal> operator:

To findthepoints closest to a given spherical position, use the <literal>&lt;-&gt;</literal> operator:

</para>

<programlisting>

<![CDATA[SELECT * FROM test ORDER BY pos <-> spoint (0.2, 0.3) LIMIT 10 ]]>

<![CDATA[CREATE INDEX test_pos_idx USING BRIN ON test (pos) WITH (pages_per_range = 16);]]>

</programlisting>

</example>

</sect1>

<sect1 id="ind.smoc">

SELECT pg_sphere_version();

pg_sphere_version

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

1.4.2

1.5.0

(1 row)

# pg_sphere extension

comment = 'spherical objects with useful functions, operators and index support'

default_version = '1.4.2'

default_version = '1.5.0'

module_pathname = '$libdir/pg_sphere'

relocatable = true

OPERATOR 14 @ (spoint, spoly),

OPERATOR 15 @ (spoint, sellipse),

OPERATOR 16 @ (spoint, sbox),

OPERATOR 17<-> (spoint, spoint) FOR ORDER BY float_ops,

OPERATOR 17<-> (spoint, spoint) FOR ORDER BY float_ops,

OPERATOR 37 <@ (spoint, scircle),

OPERATOR 38 <@ (spoint, sline),

OPERATOR 39 <@ (spoint, spath),