Comment 2 for bug 1869896

Revision history for this message
Jason Stephenson (jstephenson) wrote :

Oops! Looks like my first query got chopped up. It should be:

select a.usr, a.id, a.barcode, b.usr, b.id, b.barcode
from actor.card a
join actor.card b
on lower(a.barcode) = lower(b.barcode)
and a.id < b.id;