Hibernate Community • View topic - named parameters and PostgreSQL's cast operator (conflict)

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

named parameters and PostgreSQL's cast operator (conflict)

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

eepstein

Post subject: named parameters and PostgreSQL's cast operator (conflict)

Posted: Thu Feb 12, 2004 7:29 pm

Regular

Joined: Wed Dec 31, 2003 4:26 am
Posts: 108
Location: Berkeley, CA

I'm trying to use Postgres' very robust cast operator. The general format is:
some_value::cast-to-type

The problem is that the colons are interpreted (even in a sqlQuery) by hibernate as named parameters. Ooops. Other than explicit calling of specific postgres cast operators/functions is there a general work-around? Is there a way to ask Hibernate to be less agressive in parsing SQL that is not HQL?

Thanks.

Top

baliukas

Post subject:

Posted: Fri Feb 13, 2004 4:21 am

CGLIB Developer

Joined: Thu Aug 28, 2003 1:44 pm
Posts: 1217
Location: Vilnius, Lithuania

Try to use "CAST( some_value AS cast-to-type )" it is not postgresql specific.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum