[postgis-devel] "Casting" Between Types

Stephen Woodbridge woodbri at swoodbridge.com
Mon Jul 18 06:46:57 PDT 2016

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?

This email has been checked for viruses by Avast antivirus software.

More information about the postgis-devel mailing list