Re: Help with a selection - Mailing list pgsql-general

Hi,

I would like to remove an object that doesn’t end ‘00’ and if there are objects that start with the same 4 charcters and ending with 00.

All objects ending with 00 shall remain.

All object not ending with 00 shall remain of there is no object starting with the same 4 characters and ending with 00   

What about:

DELETE FROM tab t1

      WHERE     right (t1.col, 2) != '00'

            AND EXISTS

                   (SELECT 1

                      FROM tab t2

                     WHERE t2.col = left (t1.col, 4) || '00');

It deletes rows where the right two characters are not ‘00’ and another row with the same first four characters and ‘00’ at the end exists.

Dirk