Hi,
some vivid examples of rather simple spatial queries that
can be done in PostgreSQL after importing vector maps
from GRASS are at:
http://motivation.ru/grass/sp_q_example.html
AFAIC, things are not bad with GRASS5.0 vectors.
Absolutely, a DBMS with geometry types must be linked. I mean, moving
things from and to it.
--alex