[postgis-devel] "Casting" Between Types

[Paul Ramsey]

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

P


>
>
> ---
> 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>