Re: Insert into sintax

Josué Maldonado <josue@lamundial.hn> writes:

> 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

You've misparenthesized.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863