|
I need som ehelp concerning queries using SLEECT
... FOR UPDATE
I have two tables (see description
below)
One is the table of reference, the other one is a
table where i have daily infoirmation
I want to check the differences on the two tables
based on the fields omc_index and bsc for each cellname.
Then when I have inconsistency, I want to update
the first table with information picked up in the second table.
My query is the following
Select
t1.omc_index, t1.bsc from edw_object t1, edw_object_ref t2 WHERE
t1.cellname=t2.cellname and t1.day='20031214' and
(t1.omc_index<>t2.omc_index or t1.bsc<>t2.bsc) FOR UPDATE of t2;
I can not find much information on FOR UPDATE.
Thank you for your help
************************* Table
"public.edw_object_ref"
Column | Type | Modifiers -----------------+---------+----------- edw_group_table | text | omc_index | text | cellname | text | cellid | integer | bsc | text | country | text | super_region | text | region | text | area | text | subarea | text | zone | text | ibc | text | road | text | trial | text | subtrial | text | date | integer | Indexes: ix_cellname_edw_object_ref btree (cellname), ix_omc_index_edw_object_ref btree (omc_index) Table
"public.edw_object"
Column | Type | Modifiers -----------------+-----------------------+----------- cellname | character varying(50) | bsc | text | region | text | edw_group_table | text | omc_index | text | day | integer | cellid | integer | subarea | text | road | text | trial | text | ibc | text | subtrial | text | country | text | super_region | text | area | text | zone | text | Indexes: edw_object_day btree ("day"), ix_edw_object_omc_index btree (omc_index) |
