Re: operator does not exist: text = bytea

Karthik K L V writes: > We have a query with bind value which sometimes gets resolved to null (no > data) depending on the application scenario. > The datatype of the bindvalue and the corresponding column is String. > The same query executes fine when the value of the bindvalue is populated. > Co

Re: operator does not exist: text = bytea

Hi depesz, Thanks for your reply. But, this issue is happening only when the bind value of the query resolves to null. I am not trying to compare text to bytes. And the same query works fine when the bind value gets resolves to some String. So, looking for an option which can tell Postgres Engine

Re: operator does not exist: text = bytea

On Wed, Jul 20, 2022 at 03:02:13PM +0530, Karthik K L V wrote: > *Caused by: org.postgresql.util.PSQLException: ERROR: operator does not > exist: text = bytea Hint: No operator matches the given name and argument > types. You might need to add explicit type casts. Position: 1037* > Could you plea

Re: operator does not exist: text = bytea

Update: Followed this thread PostgreSQL: Re: Null bind variable in where clause and set *transform_null_equals to ON* in the parameter group on the AWS Console. But no luck. We are using Aurora PostgresS