Im using PostgreSQL 11.5 on Archlinux I want to have one

Question

Im using PostgreSQL 11.5 on Archlinux I want to have one

of 2 fields filled in in my database

I have a table with 3 fields

id INT Primary key,
email VARCHAR,
phone_number VARCHAR
email and phone_number are nullable,

I've added a CHECK Constraint to my table

ALTER TABLE my_table ADD CHECK(email != NULL OR phone_number != NULL);

But it just seems like doesn't work, I can INSERT into the table without providing email and phone_number,

https://dbfiddle.uk/?rdbms=postgres_11&fiddle=bbbabdba9884f8cf2abca32deba307ba

Here is an example
Also tried with x is NULL OR y is NULL, x is NULL AND y is NULL and x != NULL AND y != NULL, None of them worked

What might be the problem? How can I fix it?

0

13.08.2019

1 ответов

16 просмотров

Alexeyer Er · Accepted Answer

Alexeyer Er

Nothing equals to NULL :) Use email IS NOT NULL syntax.

0

13.08.2019

Похожие чаты

Im using PostgreSQL 11.5 on Archlinux I want to have one

1 ответов

Похожие вопросы