PostgreSQL: column "BOOLEAN_VALUE" is of type numeric but expression is of type boolean Hint: You will need to rewrite or cast the expression

Question

I was trying to insert a new data into both database server. This one works in Oracle 11g but does not work in PostgreSQL 9+. I cannot trace the issue as the error says:

column "BOOLEAN_VALUE" is of type numeric but expression is of type boolean Hint: You will need to rewrite or cast the expression.

The column is nullable and in codes below, we do not set any data.

Table Def:(Numeric)
"BOOLEAN_VALUE" NUMBER(1,0)

Domain:
@Column(name = "BOOLEAN_VALUE")
public Boolean getBooleanValue() {
    return booleanValue;
}

public void setBooleanValue(Boolean booleanValue) {
    this.booleanValue = booleanValue;
}

How data insertion:
MyData myData = new MyData();
myData.setMoneyValue("$ 120")
myServiceRepository.save(myData);

We did passing 0 or 1 as default value but none has worked. Hope someone can give me some light.

rbicchierai · Accepted Answer · 2018-05-10 15:00:55Z

1

PostgreSQL do not auto-cast int to boolean automatically, eventually you can create your own cast function.

See: https://www.postgresql.org/docs/9.4/static/sql-createcast.html

answered May 10, 2018 at 15:00

rbicchierai

1862 silver badges3 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Olahzzz Over a year ago

Thank you. The solution we did is we just changed the column definition from Numeric to Boolean type.

Marc Magon · Accepted Answer · 2022-05-21 04:13:54Z

0

For hibernate 6 you can annotate the jdbc type to integer

@JdbcTypeCode(Types.INTEGER)

private boolean booleanColumn;

answered May 21, 2022 at 4:13

Marc Magon

8678 silver badges12 bronze badges

Collectives™ on Stack Overflow

PostgreSQL: column "BOOLEAN_VALUE" is of type numeric but expression is of type boolean Hint: You will need to rewrite or cast the expression

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related