Thread: From Clause

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 //