Re: What is bad in this query ?

On 2 May 2003, Rado Petrik wrote:

> 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' .

What do you want to do in the first place??
Have  N+1 rows with name='rado' if N>0 ???

> 
> 
> 
> 
> Thanks 
>  
> 

-- 
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-210-8981112
fax:    +30-210-8981877
email:  achill@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr