Re: From select to delete - Mailing list pgsql-general

From Alexander Farber
Subject Re: From select to delete
Date
Msg-id CAADeyWgXrEZuuZpL6WAc_z5-HXCN9pP_7oY1gdEh7hM5=HLNCQ@mail.gmail.com
Whole thread Raw
In response to Re: From select to delete  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Nevermind, sorry - I've figured it out myself (for a change)

                delete from pref_scores where id<>_id and gid in
                    (select gid from pref_scores where id=_id);

                delete from pref_games where gid in
                    (select gid from pref_scores where id=_id);

                delete from pref_scores where id=_id;

Regards
Alex

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: From select to delete
Next
From: Merlin Moncure
Date:
Subject: Re: nextval skips values between consecutive calls