Skip to main content
7 events
when toggle format what by license comment
Oct 9 at 11:44 comment added M.A. Heshmat Khah Thank you, The ‌ " " is working correctly as you mentioned.
Oct 9 at 11:42 vote accept M.A. Heshmat Khah
Oct 9 at 10:02 comment added Daniel Vérité @M.A.HeshmatKhah:yes, the first column must not be quoted. In terms of UTF-8 bytes, the following sequence works for me with pg17: e2 80 8c 20 22 20 22 0A that is ZERO WIDTH NON-JOINER followed by space, double quote, space, double quote, newline.
Oct 9 at 9:45 comment added JensV @M.A.HeshmatKhah reading through the commit, it seems that you can only add quotes on the right hand side. So I would expect it to work if you remove the quotes around the ZWNJ.
Oct 9 at 7:45 comment added M.A. Heshmat Khah Hi, thanks for your response, I just tested my rules with PSQL17: the first rule above ("‌" " ") didn't cause that warning, but it still not working and there is still a ZWNJ in SELECT unaccent('۱۲۳سَلام‌علیکم۴۵۶'); -> 123سلام‌علیکم456
Oct 9 at 6:12 vote accept M.A. Heshmat Khah
Oct 9 at 7:42
Oct 8 at 20:10 history answered Daniel Vérité CC BY-SA 4.0