Hi,

Does Hibernate support any of the advanced features found in PostgreSQL? Particularly I'm interested in knowing whether SQL Arrays are supported. Also ...

What about all the cool types that are supported by Postgres like Point, etc? I think Hibernate supports some sort of custom types ... has anyone written a class to support a built in postgres type or would know how to do that?

Also I'm interested in knowing if anyone has found uses for postgres' OID values with respect to Hibernate. Since each row in a postgres database has a unique OID, could this be a way to have polymorphic foreign keys from one table to any table (instead of using <any>)?

I think this calls for a Wiki page but unfortunately I'm still asking questions instead of answering them.

It is VERY easy to support things like SQL Arrays using a UserType :)

Don't know anything about more exotic things like Point, but the story would by the same. UserType/CompositeUserType are very flexibe.


OID I'm not so sure about. Never thought about it.