Bob Pawley wrote:
> I am receiving an error message about a missing "From Clause" in an
> insert statement.
>
> I've tried a number of variations of adding a from clause with no success.
>
> Could someone help with the following statement??
>
> Insert Into p_id.loop_sequence (monitor) values(p_id.loops.monitor) ;
You can add that schema name to your search ppath, you know... saves typing.
What kind of value is p_id.loops.monitor? I think you meant to do a
select instead of values; probably this:
set search_path to 'p_id,public';
insert into loop_sequence (monitor) select monitor from loops;
> Bob Pawley
--
Alban Hertroys
alban@magproductions.nl
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede
// Integrate Your World //