I want to implement persistence in a spatial database: PosgreSQL + PostGis extension. Can I use the spatial operators like && or distance?. Can I include calls to PostreSQL functions in the where statement?

Examples of some queries:

SELECT
ID, NAME
FROM ROADS_GEOM
WHERE
GEOM && GeometryFromText('POLYGON((191232 243117,191232 243119,191234 243117,191232 243117))',-1);


SELECT the_geom FROM geom_table
WHERE distance( the_geom, GeometryFromText( 'POINT(100000 200000)', -1 ) ) < 100

Thaks in advanced:
Fernando Z.

You can use arbitary SQL functions in the where clause, but not in the select clause.

Did you mean that you can use arbitrary sql in the where clause with HQL or only with the native SQL connection?

I am also interested in using PostGIS with Hibernate...

thanks

Yes, special operators can appear in the HQL where clause, but cannot appear in the HQL select clause.

With the native JDBC connection you can do wahtever you like.

also remember the createSQLQuery option.....

The distinction being that HQL will return domain objects instead of resultsets.

Am I correct on this?

nope.

createSQLQuery ONLY return domain objects.

HQL can return domain objects and/or scalar values.

Wow...

thanks