<sect1 id="appendixes">

<title>

</title>

<sect2 id="appendixes.changelog-1-1">

<title>

</listitem>

</itemizedlist>

</sect2>

<sect2 id="appendixes.changelog-1-2">

<sect2 id="appendixes.changelog-1-1-5">

<title>

Changes from version 1.1 to 1.2

Changes from version 1.1 to 1.1.5

</title>

<itemizedlist>

<listitem>

<para>

Modify behavior of function <function>set_sphere_output_precision</function>.

</para>

</listitem>

<listitem>

<para>

Compatibility with <application>PostgreSQL</application> 9.2

and later.

</para>

</listitem>

<listitem>

<para>

Creating spath and spolygon objects &quot;as aggregate&quot;

from tables should now work.

</para>

</listitem>

<listitem>

<para>

Improved accuracy of spoint (great circle) distance calculation.

</para>

</listitem>

<listitem>

<para>

Add new contains operators consistent with the geometry operators

of the plain used in <application>PostgreSQL</application> 8.2

and later:

&lt;@ and @&gt;, the old operators @ and &tilde; still work.

</para>

</listitem>

<listitem>

<para>

Improved correctness of spatial indexing.

</para>

</listitem>

</itemizedlist>

</sect2>

Contain and overlap

</title>

<para>

On sphere, an equality relationship is rarely used. There

Onthesphere, an equality relationship is rarely used. There

are frequently questions like <emphasis>Is object

<literal>a</literal> contained by object

<literal>b</literal>?</emphasis> or <emphasis>Does object

<tbody>

<row>

<entry>

@

@ or &lt;@

</entry>

<entry>

the left object is contained by right object

the left object is contained bytheright object

</entry>

</row>

<row>

<entry>

&tilde;

&tilde; or @&gt;

</entry>

<entry>

the left object contains right object

the left object containstheright object

</entry>

</row>

<row>

<entry>

!@

!@ or !&lt;@

</entry>

<entry>

the left object is not contained by right object

the left object is not contained bytheright object

</entry>

</row>

<row>

<entry>

!&tilde;

!&tilde; or !@&gt;

</entry>

<entry>

the left object does not contain right object

the left object does not containtheright object

</entry>

</row>

<row>

<articlelang="en">

<articleinfo>

<title>

pgSphere 1.2

pgSphere 1.1.5

</title>

<author>

<surname>pgSphere development team</surname>

</para>

<para>

The project is hosted at <ulinkurl="http://pgfoundry.org/projects/pgsphere/"><citetitle>pgfoundry.org</citetitle></ulink>

and <ulinkurl="https://github.com/akorotkov/pgsphere"><citetitle>https://github.com/akorotkov/pgsphere</citetitle></ulink>

</para>

<para>

This document

pg_sphere_version(PG_FUNCTION_ARGS)

{

char*buffer= (char*)palloc(20);

sprintf(buffer,"1.2.0");

sprintf(buffer,"1.1.5");

PG_RETURN_CSTRING(buffer);

}