mapserver-postgis centroid function

[Kumar]

I got the mapfile working with 

DATA "shape FROM (select centroid(the_geom) AS shape,gid,PPIN from
cal_parcel) AS foo USING UNIQUE gid USING SRID=-1

I am still wondering why would you loose the SRID information in this
process of calculating the centroid.

Thanks for all your help.

- kumar


-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
Behalf Of Paul Ramsey
Sent: Tuesday, September 20, 2005 7:31 PM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] mapserver-postgis centroid function

Matt is right, you should retrieve precisely as many columns as you  
need, no more.  A unique id, something to do labeling with, perhaps,  
something to calculate classes with, perhaps, and the geometry  
itself. That's it.
Paul

On Sep 20, 2005, at 2:44 PM, Matthew Perry wrote:

> David.
>
> On 9/20/05, David TECHER <davidtecher at yahoo.fr> wrote: I don't  
> think so!
> Since Kumar wants to use a LABELITEM on 'PPIN'
> As a consequence,  he should use '*'because PPIN
> should be a field in his table.
>
> Well * is what's causing the problems (redundant the_geom columns).  
> How about replacing * with PPIN instead.
>
> -- 
> Matt Perry
> perrygeo at gmail.com
> http://www.perrygeo.net