Can an integer column be null?

postgresql null integer quotes postgresql-9.3
efoc picture efoc · Sep 28, 2017 · Viewed 22.7k times · Source

I made an integer column that is null by default but when I put empty double quotes "" it gives this error:

ERROR: invalid input syntax for integer: ""

Does the integer column have to be 0 then?

I am using Java to send the query to the database.

Answer

Sam Hartman picture Sam Hartman · Sep 28, 2017

An integer column can be null, but '' is an empty string not null. The right syntax for a null integer (or any other sql type) is null.

Related questions

What is the PostgreSQL equivalent for ISNULL()

In MS SQL-Server, I can do: SELECT ISNULL(Field,'Empty') from Table But in PostgreSQL I get a syntax error. How do I emulate the ISNULL() functionality ?

Read More
Best way to check for "empty or null value"

What is best way to check if value is null or empty string in Postgres sql statements? Value can be long expression so it is preferable that it is written only once in check. Currently I'm using: coalesce( trim(stringexpression),…

Read More
Select rows which are not present in other table

I've got two postgresql tables: table name column names ----------- ------------------------ login_log ip | etc. ip_location ip | location | hostname | etc. I want to get every IP address from login_log which doesn't have a row in ip_location. I …

Read More