[postgis-users] AddGeometryColumn BOX3D

[Mike Toews]

Hi Jan,

box3d is not a geometry, but it is it's very own type (along with box2d). If
you have pgAdminIII, you can browse these types (you may need to enable
visibility of "types" in the options), or if you use psql then the command
"\dT" will show all types.

Since it isn't a geometry, you can directly create it, e.g.:

create table foo(
  id serial primary key,
  box box3d
);

insert into foo(box) values('BOX3D(0 0 0, 10 10 10)'::box3d);

-Mike

On 18 October 2010 02:34, Jan Saalbach <fire at dubmosphere.de> wrote:

> Hi all,
> what is the geometry type to chose when storing BOX3D type geometries? Of
> what type does the column need to be? I mean how do I phrase this correctly?
>
> ---
> postgisdb=# SELECT AddGeometryColumn('boxes','box3d',31467,'BOX',3);
>
> FEHLER:  Invalid type name - valid ones are:
>        POINT, MULTIPOINT,
>        LINESTRING, MULTILINESTRING,
>        POLYGON, MULTIPOLYGON,
>        CIRCULARSTRING, COMPOUNDCURVE, MULTICURVE,
>        CURVEPOLYGON, MULTISURFACE,
>        GEOMETRY, GEOMETRYCOLLECTION,
>        POINTM, MULTIPOINTM,
>        LINESTRINGM, MULTILINESTRINGM,
>        POLYGONM, MULTIPOLYGONM,
>        CIRCULARSTRINGM, COMPOUNDCURVEM, MULTICURVEM
>        CURVEPOLYGONM, MULTISURFACEM,
>        or GEOMETRYCOLLECTIONM
> ---
>
> The reason I need to do this is I would like to use the &&-operator on 2
> boxes. And comparing the boxes from point3d-sets directly gives me a "not
> enough memory error".
>
> Regards,
> Jan
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101018/bb000827/attachment.html>