In my database, I have UNIQUE constraint with two columns col_1 and col2.
But, I have detected that while inserting in the database two records with the same value in col_1 and null in col_2, postgres accept it and take null values as different.
So as solution, I have added a default value. My col_2 was a date, so I have inserted a future date '2040-01-01' and in the request, I just do :
select from table where col_2 >= now();
Using JPA, I also disable it to insert a NULL value and let the database putting the default value by using insertable = flase. Please see this link for more details.
But, I have detected that while inserting in the database two records with the same value in col_1 and null in col_2, postgres accept it and take null values as different.
So as solution, I have added a default value. My col_2 was a date, so I have inserted a future date '2040-01-01' and in the request, I just do :
select from table where col_2 >= now();
Using JPA, I also disable it to insert a NULL value and let the database putting the default value by using insertable = flase. Please see this link for more details.
This comment has been removed by a blog administrator.
ReplyDelete