[postgis-devel] Re: [postgis-users] create tables smarter

[Tom Lane]

"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