Return type should be "geometry". "Box" is a PostgreSQL native datatype, not a PostGIS datatype.
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Dan Erikson > Sent: Wednesday, June 25, 2008 10:47 AM > To: PostGIS Users Discussion > Subject: [postgis-users] box2d return from function! > > > Quick question here.....might be easy for someone who has done this: > > I want to return an extent (box2d) from a plpgsql function. I can > define "box2d" as a type within the function, but only "box" in the > function return type or the out variable type. Apparently I > can't cast > from "box2d" to "box" either. > > It is possible I am approaching this all wrong. Is there an > easier way > to return the results of an extent query? > > (Postgresql 8.2) > > > Dan Erikson BNRSc > Project Manager > ------------------------------------- > Timberline Natural Resource Group > (250)-314-0875 ext 240 > #201-175 4th Avenue Kamloops BC > www.timberline.ca > ------------------------------------- > > > _______________________________________________ > postgis-users mailing list [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
