I am confused on how I can create an SQL statement containing colons. I am trying to create a view and I am using (notice the double colons):

create view MyView as (
  SELECT 
    tableA.colA as colA,
    tableB.colB as colB, 
    round(tableB.colD / 1024)::numeric, 2) as calcValue,
  FROM 
    tableA, tableB
  WHERE
    tableA.colC = 'someValue'
);

This is a postgres query and I am forced to use the double colons (::) in order to correctly run the statement.

I then pass the above statement through:

s.createSQLQuery(myQuery).executeUpdate();

and I get a:

Exception in thread "main" org.hibernate.exception.DataException: \
    could not execute native bulk manipulation query
 at org.hibernate.exception.SQLStateConverter.convert(\
    SQLStateConverter.java:102)
    ... more stacktrace...

with an output of my above statement changed as (notice the question mark):

create view MyView as (
  SELECT 
    tableA.colA as colA,
    tableB.colB as colB, 
    round(tableB.colD / 1024)?, 2) as calcValue,
  FROM 
    tableA, tableB
  WHERE
    tableA.colC = 'someValue'
);

Obviously, hibernate confuses my colons with named parameters.

Is there a way to escape the colons (a google suggestion that mentions that a single colon is escaped as a double colon does NOT work) or another way of running this statement?

Thanks.