From: | Abhra Kar <abhra(dot)kar(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | missing FROM-clause entry for table bbbb |
Date: | 2018-01-16 11:36:01 |
Message-ID: | CAFNULEc2acaYAq2-6+spfSgp04AnmfijrfRLE9ked5wv711LqA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
Hi
I tried to modify below sql command in postgres syntax---
insert into aaaa (id, groupid, ele_id, ro_element_id) ")
select bbbb.nextval, :groupid, gosp.neteleid, gosp.hodev
from net_ele gos, net_gos_prop gosp "
where gos.eid in ( :eids ) and gos.id = gosp.net_element_id and
gos.id not in (select ealjs.element_id from aaaa ealjs where
ealjs.groupid = :groupid)
If I run this it gives error for ":".If I remove : then I will get error
like missing FROM-clause entry for table bbbb.
What is the issue here and what should be exact query in postgressql
Thanks
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2018-01-16 14:10:58 | Re: missing FROM-clause entry for table bbbb |
Previous Message | Adam =?utf-8?Q?Sj=C3=B8gren?= | 2018-01-16 10:18:26 | Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 |
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2018-01-16 14:10:58 | Re: missing FROM-clause entry for table bbbb |
Previous Message | Hugo Lourenco | 2018-01-08 11:00:57 | Re: Streaming replication |