Timeline for PostgreSQL: Use column with hash based on other columns as unique index?
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 21, 2015 at 8:02 | comment | added | Erik van de Ven | Ahaa very clever! ;) Yes indeed, probably I had to add a delimiter or something... Anyway, Feike's answer solved my problem so far ;) | |
| Jan 20, 2015 at 17:10 | comment | added | Daniel Vérité |
Are you sure the way you're using md5 with concat is correct to generate a unique key? It seems like you interpret product_id=123 and price_old=4 as identical to product_id=12 and price_old=34, since both produce 1234 where concatenated.
|
|
| Jan 20, 2015 at 12:46 | history | answered | Erik van de Ven | CC BY-SA 3.0 |