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

[Mark Cave-Ayland]

Markus Schaber wrote:

> But when you do operations like string concatentation, or intersections
> etc, the result type may require different typemods.

Hi Markus,

I don't think that would be a problem; think about the case where you 
have this:

SELECT 'name1'::varchar || ' ' || 'name2'::varchar;

I could expect both name1 and name2 to come from a varchar(5) column, 
and whilst the above calculation will work fine and return a new result, 
I would not expect to be able to fit that result back into a varchar(5) 
column.


ATB,

Mark.

-- 
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063