<html>
<head>
</head>
<body>Hallo Jorge<br />
<br />
You can absolute have different PostGIS version in different databases in the same instance. <br />
The sql-part of the functions tells tells what library to read from.<br />
<br />
When I was working with the distance functions I even ran functions from different versions in the same query to compare the result easier in big datasets. If you want to do something like that you just install one version and then make another function with another name pointing to the other versions library.<br />
<br />
To get one st_distance for instance from 1.5 and one from trunk you can install the 1.5 and then run:<br />
<span style="font-size: 10pt;">CREATE OR REPLACE FUNCTION trunk_distance(geometry, geometry)<br />
RETURNS double precision AS<br />
'$libdir/postgis-2.0', 'LWGEOM_mindistance2d'<br />
LANGUAGE 'c' IMMUTABLE STRICT<br />
COST 100;<br />
ALTER FUNCTION trunk_distance(geometry, geometry) OWNER TO postgres;</span><br />
<br />
<br />
then you can do queries like:<br />
<br />
select st_distance(a.the_geom, b.the_geom) - trunk_distance(a.the_geom, b.the_geom) from .....<br />
<br />
At least it works for most of the functions and can be very handy.<br />
<br />
HTH<br />
Nicklas<br />
<br />
<br />
2010-05-02 Jorge Arevalo wrote:<br />
<br />
Hello,<br />
><br />
>I'd like to test the code I'm developing (WKT Raster) with 2 versions<br />
>of PostGIS: The stable branch (1.4 based) and the development branch.<br />
>What would be the best way to do this? 2 instances of PostgreSQL<br />
>running? spatially enable 2 postgresql databases with different<br />
>versions of postgis? Is it possible?<br />
><br />
>Thanks in advance, and best regards,<br />
>Jorge<br />
><br />
>----<br />
>http://www.gis4free.org/blog<br />
>_______________________________________________<br />
>postgis-devel mailing list<br />
>postgis-devel@postgis.refractions.net<br />
>http://postgis.refractions.net/mailman/listinfo/postgis-devel<br />
><br />
>
</body>
</html>