X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id CFD2247630C
	for <pgsql-sql@postgresql.org>; Fri,  2 May 2003 09:23:19 -0400 (EDT)
Received: from shop.sme.sk (episoftware.casablanca.sk [217.11.230.150])
	by postgresql.org (Postfix) with ESMTP id D178F476128
	for <pgsql-sql@postgresql.org>; Fri,  2 May 2003 09:23:18 -0400 (EDT)
Received: from [193.58.192.97] (helo=juice)
	by shop.sme.sk with esmtp (Exim 3.35 #1 (Debian)) id 19BaFg-0001W1-00
	for <pgsql-sql@postgresql.org>; Fri, 02 May 2003 15:07:00 +0200
Received: from 192.168.1.25 ([192.168.1.25]) by juice
	for pgsql-sql@postgresql.org; Fri, 2 May 2003 15:22:02 +0200
Subject: What is bad in this query ?
From: Rado Petrik <r.p@szm.sk>
To: PostgreSQL-mailinglist <pgsql-sql@postgresql.org>
Content-Type: text/plain
Organization: 
Message-Id: <1051881697.29275.14.camel@caj>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.2.3 
Date: 02 May 2003 15:21:37 +0200
Content-Transfer-Encoding: 7bit
X-Spam-Status: No, hits=-11.5 required=5.0
	tests=BAYES_10,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/21
X-Sequence-Number: 13186

Hi, 

What is bad in this query ? 

SELECT CASE 
	WHEN EXIST(SELECT * FROM user WHERE name=rado) 
		THEN (INSERT INTO user VALUES('rado')) 
	END; 

PostgreSQL return 

ERROR:  parser: parse error at or near "INTO"

table user have only one column 'name' .




Thanks 
 
-- 
Rado Petrik <r.p@szm.sk>