Skip to main content

Questions tagged [coalesce]

The tag has no usage guidance.

2 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0 votes
1 answer
15 views

coalesce works only once

I have a table with redundant values in the first two columns: sqlite> select * from amino where "lebensmittel" = 'Walnüsse'; Lebensmittel Protein pro 100g Histidin Isoleucin Leucin ...
ceving's user avatar
  • 339
0 votes
0 answers
899 views

PostgreSQL COALESCE arguments change resulting timezone for DateTime

I have strange behaviour of COALESCE function of PostgreSQL. Depending on arguments of this function the result is different: SELECT "CreatedOn", -- 7/24/2020 8:15:03 AM COALESCE(&...
Artem Repko's user avatar