[postgis-devel] "Casting" Between Types

Paul Ramsey pramsey at cleverelephant.ca
Mon Jul 18 06:55:50 PDT 2016

On Mon, Jul 18, 2016 at 6:46 AM, Stephen Woodbridge <woodbri at swoodbridge.com
> wrote:

> On 7/18/2016 9:40 AM, Paul Ramsey wrote:
>> I found this page by accident in the SQL/MM doco this morning and it
>> tickled my interest. Basically it describes when one should allow
>> equivalence between types (I guess if one has modelled spatial in the DB
>> as 21 different types, it strictly is "casting", but nobody has done
>> that).
>> What I find pleasant is it's an official page that says "hey, don't be
>> anal retentive losers about allowing single-ton multi-geometries to pass
>> as singletons", which would be a nice improvement. In general, having a
>> bit more knowledge of the geometry class structure would probably make
>> things nicer (so the "type" restriction could be smarter and a polygon
>> could be inserted into a multi-polygon column).
>> Anyways, just random thoughts for the moment.
> And things like st_startpoint() and linear refering functions, etc
> would/should behave nicely when passed a singleton multilinestring?

yes, exactly, it's a nit which has been bugging me for a while, but it was
there "to be correct" and since there's this nice alternative reference of
correctness, I thought I'd bring it up


> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-devel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20160718/318aa2a2/attachment.html>

More information about the postgis-devel mailing list