16 Jan
2021
16 Jan
'21
5:41 p.m.
On Sat, Jan 16, 2021 at 04:37:56PM +0000, Alasdair G Kergon wrote:
select p.email,COALESCE(first_name || ' ', '') || last_name,voucher_number from conference_person cp join person p using (person_id) where voucher_number is not null and voucher_number not ilike 'X%' order by voucher_number::int; ^ Where I spotted someone had two accounts that could not be merged (they wanted different photos/bios to appear on them) I used the same voucher code on both of them but added an X prefix on one of them for it to be ignored.
Alasdair