[postgis-devel] Re: [postgis-users] create tables smarter
Tom Lane
tgl at sss.pgh.pa.us
Thu Jun 5 08:28:57 PDT 2008
"Obe, Regina" <robe.dnd at cityofboston.gov> writes:
> Which brings back to the point that you still need to support the
> untypemod version. Is that allowed similar to like how we have?
> varchar (which is really unlimited) vs. varchar(255)
> and when you concatenate you get -> text
> And also a construct such as
> SELECT CAST(ST_Intersection(a.the_geom, b.the_geom) As
> Geometry('POLYGON',....))
> which would throw an error if the intersection does not return the right
> cast type you note.
Yup, both those cases would work "as expected" AFAICS.
regards, tom lane
More information about the postgis-devel
mailing list