Re: [postgis-users] pl/pgsql getting ST_X output as REAL

2010-10-05 Thread Ralf Suhr
Hi Jan, ST_X is a function returning double precision. psql -d your_db -c "\df ST_X" can guide you. Gr Ralf Am Dienstag 05 Oktober 2010 16:12:29 schrieb Jan Saalbach: > Hi all, > on my journey to learning PostgreSQL and PostGis I am now trying to > write a function in pl/pgsql. In this little p

[postgis-users] trouble installing postgis 1.5.2 in Ubuntu

2010-10-05 Thread Mukesh Subedee
Hi, I am new to PostGIS and Postgres as well. I am trying to install PostGIS on Postgres 8.4.4 running on Ubuntu 10.04 LTS. I installed all the dependencies: GEOS 3.2.2, Proj-4.7, libxml2-2.7.7, gdal-1.7.2 and all the installation seems to go well. I have Postgres server up and running in m

Re: [postgis-users] refractions web site

2010-10-05 Thread Andreas Forø Tollefsen
Again. Both Postgis and Refractions websites are down. Any idea what is going on? 2010/9/21 Maria Arias de Reyna > El Tuesday 21 September 2010, Guillaume Sueur escribió: > > Hi, > > > > What's wrong with www.refractions.net website and its sub-domains like > > postgis.refractions.net ? Has it m

[postgis-users] pl/pgsql getting ST_X output as REAL

2010-10-05 Thread Jan Saalbach
Hi all, on my journey to learning PostgreSQL and PostGis I am now trying to write a function in pl/pgsql. In this little program I would like to determine the frequency of different x-values of POINT3D objects to get an idea about how many "rows" were digitized. Therefore I would like to u