Hi Guys, I'm one of the hibernate(http://hibernate.org) team commiters and I'm here to ask you for a little help :-) I'm trying to improve the support of hibernate to Postgre(and other databases), but I'm don't have *that* knowledge in database functions and behavior. I'm already done a couple of improvements, but I'm trying to map all your functions, for example, to allow our users to use most of database functions with HQL. And to do that we must do some changes.
What we must do(ok, what we *can* do :-) ) is change the file bellow, adding the functions that are useful to this file: http://anonsvn.jboss.org/repos/hibernate/core/trunk/core/src/main/java/org/hibernate/dialect/PostgreSQLDialect.java This class is just a class that says to hibernate "hey, I'm a Postgree database and I'm work that way". Here we register database types(with registerColumnType()), functions(with registerFunction()), and override some methods methods that says to hibernate some database behaviors. This class extends our base Dialect, that is just a class with some basic info. http://anonsvn.jboss.org/repos/hibernate/core/trunk/core/src/main/java/org/hibernate/dialect/Dialect.java So, if someone wanna help, please let me know :-) Cya! -- http://plentz.org/ "Provide options, don't make lame excuses."