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