[postgis-users] function geomfromtext(box3d, integer) does not exist

[Achim Weßling]

Hallo,

if have some difficulties doing the following SELECT:

SELECT objnr, objart, bemerkung, asText(the_geom) AS the_geom 
    FROM f001_e_fla 
    WHERE the_geom && GeomFromText('BOX3D(3446100.431483785
5773647.50152, 3446321.932947913 5773823.243699623)'::box3d, 31467);

I get the following error message:

function geomfromtext(box3d, integer) does not exist

What's wrong? If I run this SELECT on my old maschine (postgis 0.8.1 on
postgresql 7.4) I've no problem. But on my new system (postgis 1.0.0 RC6
on postgresql 8.0) I get the above error?

in postgis 0.8.1 the function takes the parameters as geometry and int4,
in postgis 1.0.0 RC6 the function takes the parameters as text and int
4!

But the docu for RC 6 which I downloaded just a few days, has an example
of using box3d as I did!

Any hint would be nice!
-- 
Mit freundlichem Gruß

Achim Weßling
===========================================
INFOKOM Gütersloh AöR
Fachbereich II - Technische Anwendungen
Herzebrocker Str. 140
33334 Gütersloh
Tel.: 05241/85-2926
Achim.Wessling at gt-net.de
http://www.infokom-gt.de