Regina crafted matrix of functions available in upcoming PostGIS 1.5. Currently, PostGIS 1.5 is available from trunk in the Subversion repository.
The PostGIS 1.5 documentation is available under the manual-svn node and here is the PostGIS Function Support Matrix.
Regina, great job!
By the way, there is an interesting problem with check marks. does anyone know how to define check marks based on Unicode and make them visible in IE8?
I’m writing a small driver for readint WKT Raster data from RASTER column in PostGIS-enabled database and I want to report name of database I’m connected with. My reader eats connection string, and here I’ve fallen in love with Python lambda.
Given connstr stores connection string to PostgreSQL database in format well-known from libpq, single-line anonymous function can do the whole job:
filter(lambda db: db[:6] == 'dbname', connstr.split())[0].split('=')[1]Complete example:
$ python
Python 2.5.2 (r252:60911, Oct 5 2008, 19:24:49)
>>> connstr = "dbname='rtest' host='localhost' user='mloskot'"
>>> filter(lambda db: db[:6] == 'dbname', connstr.split())[0].split('=')[1]
"'rtest'"
>>> connstr = "password='xxx' port=5432 dbname='rtest' host='localhost' user='mloskot'"
>>> filter(lambda db: db[:6] == 'dbname', connstr.split())[0].split('=')[1]
"'rtest'"
>>>Have fun!