What is bad in this query ? - Mailing list pgsql-sql

From Rado Petrik
Subject What is bad in this query ?
Date
Msg-id 1051881697.29275.14.camel@caj
Whole thread Raw
Responses Re: What is bad in this query ?  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Re: What is bad in this query ?  (Rod Taylor <rbt@rbt.ca>)
List pgsql-sql
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>



pgsql-sql by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: timeofday() and now() issue..
Next
From: "Matt Mello"
Date:
Subject: Re: implied FROM