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(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr