X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 8C2B1475A45
	for <pgsql-sql@postgresql.org>; Fri,  2 May 2003 10:32:39 -0400 (EDT)
Received: from nat.inquent.com (unknown [216.208.117.7])
	by postgresql.org (Postfix) with ESMTP id 876D6475458
	for <pgsql-sql@postgresql.org>; Fri,  2 May 2003 10:32:38 -0400 (EDT)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by nat.inquent.com (8.12.8p1/8.12.8) with ESMTP id h42EWqRg094560;
	Fri, 2 May 2003 10:32:53 -0400 (EDT) (envelope-from rbt@rbt.ca)
Subject: Re: What is bad in this query ?
From: Rod Taylor <rbt@rbt.ca>
To: Rado Petrik <r.p@szm.sk>
Cc: PostgreSQL-mailinglist <pgsql-sql@postgresql.org>
In-Reply-To: <1051881697.29275.14.camel@caj>
References: <1051881697.29275.14.camel@caj>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-CA3C7af041m7IWUPvcD5"
Organization: 
Message-Id: <1051885971.94424.29.camel@jester>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.2.4 
Date: 02 May 2003 10:32:52 -0400
X-Spam-Status: No, hits=-40.5 required=5.0
	tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,PGP_SIGNATURE_2,
	REFERENCES,REPLY_WITH_QUOTES,UPPERCASE_25_50, USER_AGENT_XIMIAN
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200305/24
X-Sequence-Number: 13189

--=-CA3C7af041m7IWUPvcD5
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Fri, 2003-05-02 at 09:21, Rado Petrik wrote:
> Hi,=20
>=20
> What is bad in this query ?=20
>=20
> SELECT CASE=20
> 	WHEN EXIST(SELECT * FROM user WHERE name=3Drado)=20
> 		THEN (INSERT INTO user VALUES('rado'))=20
> 	END;=20

The INSERT is bad.

Try something like:
INSERT INTO user (name)
	SELECT name FROM user WHERE name =3D 'rado';


--=20
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

--=-CA3C7af041m7IWUPvcD5
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (FreeBSD)

iD8DBQA+soGT6DETLow6vwwRAvhhAJ0W7f9yefj0h4bd1Jkmw7Xt7Z+IAQCfRE0G
vBRbUk5P7a65SAgIpare33k=
=0sYl
-----END PGP SIGNATURE-----

--=-CA3C7af041m7IWUPvcD5--