Re: Insert into sintax

What table is lnpedpk in - ped_cam? What table is ped_pk in - ped_pro and
ped_cam?

-----Original Message-----
From: Josué Maldonado [mailto:josue(at)lamundial(dot)hn]
Sent: Thursday, August 05, 2004 3:50 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Insert into sintax

Hello list,

Could anyone point me the rigth way to write this query:

INSERT INTO ped_cam
(SELECT * from ped_pro where ped_pk=lnpedpk)
WHERE NOT EXISTS (SELECT ped_pk FROM ped_cam
WHERE ped_pk=lnpedpk);

I got this:
ERROR: syntax error at or near "WHERE" at character 63

Thanks,

--
Sinceramente,
Josué Maldonado.
"¿Porqué es tan difícil <querer>, mientras es tan fácil <desear>? Porque
en el deseo se expresa la impotencia, y en el querer, la fuerza. "

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster