[postgis-devel] [WKT Raster] Requirement of PostgreSQL

[Mark Cave-Ayland]

Mateusz Loskot wrote:

> Hi,
> 
> I'd like to ask and discuss what is (or should be) oldest
> version of PostgreSQL required by WKT Raster.
> 
> Currently, the chain of dependencies is a follows:
> 
> PostgreSQL <- PostGIS <- WKT Raster
> 
> WKT Raster requires [1] PostGIS of current SVN trunk
> and PostGIS 1.3.5 does not work here.
> According to the SVN manual, PostGIS in trunk requires PostgreSQL 8.1+
> It implies, WKT Raster requires PostgreSQL 8.1+ as well.
> 
> So, I would like to confirm WKT Raster requires PostgreSQL 8.1+
> and that we can safely use features of PostgreSQL 8.1+.
> For instance, I would like to switch to new-style function declarations
> available in PL/PGSQL of PostgreSQL 8.0+, and get rid of aliases.
> 
> Any objections?

None from me. For SVN trunk, I've already moved everything over to $$ 
body quoting (see 
http://svn.refractions.net/postgis/trunk/postgis/postgis.sql.in.c) which 
gets rid of a lot of apostrophe quoting nastiness. If I were writing 
PostGIS from scratch today, I'd probably use IN/OUT parameters too since 
in some cases you can remove aliases from SRFs used within queries.


HTH,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063