On Wed, Aug 31, 2005 at 12:30:14 +0200,
David Sankel <camior(at)gmail(dot)com> wrote:
>
> DELETE FROM pg_user
> WHERE usesysid = ANY ( SELECT grolist
> FROM pg_group
> WHERE groname = 'somegroupname' )
>
> But, alas, it doesn't. Neither does any combination of IN and ANY. It seems
> to me like this should work since the same syntax works if we weren't
> talking about arrays.
In 8.1 you will be able to replace the second FROM with USING to do a join
in a DELETE. Currently you need to take advantage of the missing from
feature.