Hi All,
Could anyone let us know how to understand the attached query ?
From what I know this is an Orion (java application server) generated
query for postgresql...
The C-JDBC parsing seems to fail because we can't find a proper FROM
keyword to select the depedencies of the query.
Since this is not seemingly SQL92 standard, can anyone from the
postgresql team give us some information ?
Thank you,
Nicolas Modrzyk,
>------------------------------------------------------------------------
>
>create table temp.zz_deltasrollAll_1100866542312_cache2_weekly as select hubid, czcode, type2, order_, itemid, item,
hour,caseid, '2004WEEK47-2004WEEK48'::text as roll, "2004WEEK47-2004WEEK48" as value from
temp.zz_deltasroll_1100866542312union select hubid, czcode, type2, order_, itemid, item, hour, caseid,
'2004WEEK48-2004WEEK49'::textas roll, "2004WEEK48-2004WEEK49" as value from temp.zz_deltasroll_1100866542312 union
selecthubid, czcode, type2, order_, itemid, item, hour, caseid, '2004WEEK49-2004WEEK50'::text as roll,
"2004WEEK49-2004WEEK50"as value from temp.zz_deltasroll_1100866542312 union select hubid, czcode, type2, order_,
itemid,item, hour, caseid, '2004WEEK50-2004WEEK51'::text as roll, "2004WEEK50-2004WEEK51" as value from
temp.zz_deltasroll_1100866542312union select hubid, czcode, type2, order_, itemid, item, hour, caseid,
'2004WEEK51-2004WEEK52'::textas roll, "2004WEEK51-2004WEEK52" as value from temp.zz_deltasroll_1100866542312 union
selecthubid, czcode, type2, order_, itemid, item, hour, caseid, '2004WEEK52-2005WEEK01'::text as roll,
"2004WEEK52-2005WEEK01"as value from temp.zz_deltasroll_1100866542312 union select hubid, czcode, type2, order_,
itemid,item, hour, caseid, '2005WEEK01-2005WEEK02'::text as roll, "2005WEEK01-2005WEEK02" as value from
temp.zz_deltasroll_1100866542312union select hubid, czcode, type2, order_, itemid, item, hour, caseid,
'2005WEEK02-2005WEEK03'[... 10 more lines]
>
