From: | Alban Hertroys <alban(at)magproductions(dot)nl> |
---|---|
To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
Cc: | Postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: From Clause |
Date: | 2006-12-07 09:06:17 |
Message-ID: | 4577D989.90506@magproductions.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)magproductions(dot)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 //
From | Date | Subject | |
---|---|---|---|
Next Message | Willy-Bas Loos | 2006-12-07 09:08:50 | Cast boolean to text |
Previous Message | Ragnar | 2006-12-07 08:56:28 | Re: Anything I can do to speed up this query? |