[CDBI] Re: Working with OGC geometry data types...

Edward J. Sabol sabol at alderaan.gsfc.nasa.gov
Wed Mar 1 00:04:38 GMT 2006


> I'll try the SQL overrides as soon as I get a chance tomorrow. I'll
> post the results here.

Judd, I just realized that what I previously posted probably won't work. I'd
try the following instead:

__PACKAGE__->set_sql(Retrieve => <<'');
SELECT __ESSENTIAL__, geometry=AsText(geometry)
FROM   __TABLE__
WHERE  %s

__PACKAGE__->set_sql(RetrieveAll => <<'');
SELECT __ESSENTIAL__, geometry=AsText(geometry)
FROM   __TABLE__

Or possibly "AsText(geometry) AS geometry", depending upon your DBMS's SQL
dialect.

Later,
Ed




More information about the ClassDBI mailing list