From: Andreas Joseph Krogh <andreak@officenet.no>
Organization: OfficeNet AS
To: pgsql-sql@postgresql.org
Subject: Re: Help with UNION query
Date: Sun, 4 Sep 2005 20:08:20 +0200
User-Agent: KMail/1.8.91
References: <200509041914.33245.andreak@officenet.no>
In-Reply-To: <200509041914.33245.andreak@officenet.no>
MIME-Version: 1.0
Content-Type: multipart/signed; boundary="nextPart12949201.sbyUKUP0Fh";
	protocol="application/pgp-signature"; micalg=pgp-sha1
Content-Transfer-Encoding: 7bit
Message-Id: <200509042008.21080.andreak@officenet.no>

--nextPart12949201.sbyUKUP0Fh
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Replying to my self...

Here's a somewhat simpler version without the IN-queries:

SELECT g.id
from onp_group g, onp_user_group ug
where g.groupname =3D ug.groupname AND ug.username =3D 'andreak'
UNION
SELECT gc.child_id
=46ROM onp_group_children gc, onp_group g, onp_user_group ug
WHERE gc.group_id =3D g.id AND g.groupname =3D ug.groupname
AND ug.username =3D 'andreak';

But I would very much appreciate if someone manages to rewrite this query s=
o=20
that it doesn't specify ug.username=3D'anderak' twice.

=2D-=20
Andreas Joseph Krogh <andreak@officenet.no>
Senior Software Developer / Manager
gpg public_key: http://dev.officenet.no/~andreak/public_key.asc
=2D-----------------------+---------------------------------------------+
OfficeNet AS            | The most difficult thing in the world is to |
Hoffsveien 17           | know how to do a thing and to watch         |
PO. Box 425 Sk=F8yen      | somebody else doing it wrong, without       |
0213 Oslo               | comment.                                    |
NORWAY                  |                                             |
Phone : +47 22 13 01 00 |                                             |
Direct: +47 22 13 10 03 |                                             |
Mobile: +47 909  56 963 |                                             |
=2D-----------------------+---------------------------------------------+

--nextPart12949201.sbyUKUP0Fh
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)

iD8DBQBDGzgVUopImDh2gfQRAlx1AJ9ZhiD+IzCZdc35JafB15cOUlUqXgCffvsO
XMWK5eG1sFRF88qgtomDeMo=
=r0C/
-----END PGP SIGNATURE-----

--nextPart12949201.sbyUKUP0Fh--