Timeline for Does PostgreSQL handle case-insensitive database as good as others? [closed]
Current License: CC BY-SA 4.0
10 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Feb 5, 2021 at 22:46 | history | closed |
nbk Michael Green John K. N. Marco Colin 't Hart |
Needs more focus | |
Jan 30, 2021 at 17:51 | vote | accept | Hamid Mayeli | ||
Jan 30, 2021 at 14:23 | answer | added | Daniel Vérité | timeline score: 3 | |
Jan 30, 2021 at 9:30 | history | edited | Hamid Mayeli | CC BY-SA 4.0 |
Change the title
|
Jan 30, 2021 at 9:26 | comment | added | Hamid Mayeli |
@mustaccio, You are absolutely right. a and A have equal weight, so do b and B . and I am surprised because I didn't expect changing the value of one row to affect others while they have the same weight. In the end, this is not my question as I understand both results are correct however it is not consistent.
|
|
Jan 30, 2021 at 9:15 | review | Close votes | |||
Feb 5, 2021 at 22:46 | |||||
Jan 30, 2021 at 2:42 | comment | added | mustaccio |
You seem to have three different questions here, two of which are opinion-based and as such not appropriate. As for your first question, since you request case-insensitive sort, both A and a have equal weight, and the engine is within its rights to return them in any order, so I don't understand what you find surprising.
|
|
Jan 30, 2021 at 1:04 | history | edited | Hamid Mayeli | CC BY-SA 4.0 |
Fix a grammatical issue.
|
Jan 30, 2021 at 0:56 | review | First posts | |||
Jan 30, 2021 at 8:58 | |||||
Jan 30, 2021 at 0:55 | history | asked | Hamid Mayeli | CC BY-SA 4.0 |