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@lamundial.hn]
Sent: Thursday, August 05, 2004 3:50 PM
To: pgsql-general@postgresql.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