Re: Postgres SQL unable to handle Null values for Text datatype - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Postgres SQL unable to handle Null values for Text datatype
Date
Msg-id FFAFDCD7-AB02-4606-8D51-9F89EC5696B1@thebuild.com
Whole thread Raw
In response to Postgres SQL unable to handle Null values for Text datatype  (Karthik K L V <venkata.karthik4u@gmail.com>)
List pgsql-general

> On Sep 5, 2022, at 23:10, Karthik K L V <venkata.karthik4u@gmail.com> wrote:
> The above query fails with the below exception when the value of ?1 resolves to null.
> org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = bytea
>   Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
>   Position: 64

This is a Hibernate issue.  If you use setParameter with a NULL without specifying the type, it assumes bytea (with the
PostgreSQLJDBC driver, at least).  You'll need to use the three-parameter form of setParameter() that specifies a type,
ifthe value is going to be NULL.  You can also use the setXXXX methods on SQLQuery, since the type is specified by the
particularmethod there. 

That being said, PostgreSQL's handling of NULL string values is different from Oracle's, and this is an area that code
changesare often required. 


pgsql-general by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: Postgres SQL unable to handle Null values for Text datatype
Next
From: Jeffrey Walton
Date:
Subject: Re: Determine if a user and database are available