Invalid input syntax for type date: "\N" in postgresql when fetching data

Question

I'm using postgresql and getting this sql error:

org.postgresql.util.PSQLException: ERROR: invalid input syntax for type date: "\N"

Here is my code:

SELECT * FROM person WHERE  person.dob = '\N' OR person.dob = '1994-01-16';

How can I allow Null values? so what should I add to this SQL statement?

Ertuğrul Çetin · Accepted Answer · 2017-06-10 01:15:20Z

2

Try this following code:

SELECT * FROM person WHERE  person.dob is null OR person.dob = '1994-01-16';

Ertuğrul Çetin

5,2615 gold badges42 silver badges79 bronze badges

answered Jun 10, 2017 at 1:07

developer_hatch

16.3k3 gold badges47 silver badges79 bronze badges

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

8 Comments

@ErtuğrulÇetin Fantastic! don't forget accept the answer :)

of course but it says I need to wait 6 mins so I'm waiting :)

also for updating and inserting(nulls) what should I use?

@ErtuğrulÇetin Aah ah ah... for that answer is another price ;)

ahahahha come on :)))

|