Оффтоп
1С и PostgreSQL - это безумно круто. Порой даже вот так безумно:
/style_images/CaliV6/read_more.gif
SELECT _Reference13_Q_000_T_002._Code AS f_2, _Reference11_Q_000_T_001._Description AS _sf_1, CASE WHEN _V8TblAli1_Q_000_T_003._Fld1563 IS NULL THEN CAST(0 AS NUMERIC(15,2)) ELSE _V8TblAli1_Q_000_T_003._Fld1563 END AS f_3, _V8TblAli2_Q_000_T_005._Value2_TYPE AS f_4, _V8TblAli2_Q_000_T_005._Value2_S AS f_5, _V8TblAli2_Q_000_T_005._Value2_RTRef AS f_6, _V8TblAli2_Q_000_T_005._Value2_RRRef AS f_7, CASE WHEN _V8TblAli2_Q_000_T_005._Fld1837Balance IS NULL THEN CAST(0 AS NUMERIC(28,3)) ELSE _V8TblAli2_Q_000_T_005._Fld1837Balance END AS f_8 FROM _Reference11 _Reference11_Q_000_T_001 LEFT OUTER JOIN _Reference13 _Reference13_Q_000_T_002 ON _Reference11_Q_000_T_001._IDRRef = _Reference13_Q_000_T_002._OwnerIDRRef LEFT OUTER JOIN ( SELECT _InfoReg1560_IR2._Fld1563 AS _Fld1563, _InfoReg1560_IR2._Fld1561RRef AS _Fld1561RRef FROM ( SELECT _InfoReg1560._Fld1561RRef AS _Fld1561RRef, _InfoReg1560._Fld1562RRef AS _Fld1562RRef, MAX(_InfoReg1560._Period) AS _MAXPERIOD FROM _InfoReg1560 WHERE _InfoReg1560._Period <= '2008-05-20 23:59:59'::timestamp AND _InfoReg1560._Fld1562RRef = '\\204\\016\\024\\011\\276L\\222\\222O-\\260f^TQ\\237'::bytea GROUP BY _InfoReg1560._Fld1561RRef, _InfoReg1560._Fld1562RRef ) _V8TblAli1_IR1 INNER JOIN _InfoReg1560 _InfoReg1560_IR2 ON _V8TblAli1_IR1._Fld1561RRef = _InfoReg1560_IR2._Fld1561RRef AND _V8TblAli1_IR1._Fld1562RRef = _InfoReg1560_IR2._Fld1562RRef AND _V8TblAli1_IR1._MAXPERIOD = _InfoReg1560_IR2._Period ) _V8TblAli1_Q_000_T_003 ON _Reference11_Q_000_T_001._IDRRef = _V8TblAli1_Q_000_T_003._Fld1561RRef LEFT OUTER JOIN _InfoReg2407 _InfoReg2407_Q_000_T_004 ON _Reference11_Q_000_T_001._IDRRef = _InfoReg2407_Q_000_T_004._Fld2408RRef LEFT OUTER JOIN ( SELECT _V8TblAli1_R._Value2_TYPE AS _Value2_TYPE, _V8TblAli1_R._Value2_S AS _Value2_S, _V8TblAli1_R._Value2_RTRef AS _Value2_RTRef, _V8TblAli1_R._Value2_RRRef AS _Value2_RRRef, CASE WHEN SUM(_V8TblAli1_R._Fld1837Balance) IS NULL THEN CAST(0 AS NUMERIC(28,3)) ELSE SUM(_V8TblAli1_R._Fld1837Balance) END AS _Fld1837Balance FROM ( SELECT _AccTtl21850_R._Value2_TYPE AS _Value2_TYPE, _AccTtl21850_R._Value2_S AS _Value2_S, _AccTtl21850_R._Value2_RTRef AS _Value2_RTRef, _AccTtl21850_R._Value2_RRRef AS _Value2_RRRef, _AccTtl21850_R._Fld1837 AS _Fld1837Balance FROM _AccTtl21850 _AccTtl21850_R INNER JOIN tt27 Accsd20c8cdb515d44d5a77f04d600f19517_Accs ON Accsd20c8cdb515d44d5a77f04d600f19517_Accs._IDRRef = _AccTtl21850_R._AccountRRef AND Accsd20c8cdb515d44d5a77f04d600f19517_Accs._Cnt = 2 WHERE _AccTtl21850_R._Value1_TYPE = '\\010'::bytea AND _AccTtl21850_R._Value1_RTRef = '\\000\\000\\000\\006'::bytea AND _AccTtl21850_R._Value1_RRRef = '\\252F\\0000HuM"\\021\\333ti\\002C\\245\\357'::bytea AND _AccTtl21850_R._Fld1833RRef = '\\257\\327\\0000HuM#\\021\\332<\\316\\305\\006\\344\\231'::bytea AND _AccTtl21850_R._Period = '3999-11-01 00:00:00'::timestamp AND _AccTtl21850_R._Fld1837 <> 0 UNION ALL (SELECT _AccntRegED1852_TED2._Value_TYPE AS _Value2_TYPE, _AccntRegED1852_TED2._Value_S AS _Value2_S, _AccntRegED1852_TED2._Value_RTRef AS _Value2_RTRef, _AccntRegED1852_TED2._Value_RRRef AS _Value2_RRRef, CAST(CASE WHEN _AccntReg1832_R._Correspond = 0 THEN - _AccntReg1832_R._Fld1837 ELSE _AccntReg1832_R._Fld1837 END AS NUMERIC(21,3)) AS _Fld1837Balance FROM _AccntReg1832 _AccntReg1832_R LEFT OUTER JOIN _Acc2_ExtDim1799 _Acc2_ExtDim1799_TEDAcc1 ON _Acc2_ExtDim1799_TEDAcc1._Acc2_IDRRef = _AccntReg1832_R._AccountRRef AND _Acc2_ExtDim1799_TEDAcc1._LineNo = 1 LEFT OUTER JOIN _AccntRegED1852 _AccntRegED1852_TED1 ON _AccntRegED1852_TED1._RecorderTRef = _AccntReg1832_R._RecorderTRef AND _AccntRegED1852_TED1._RecorderRRef = _AccntReg1832_R._RecorderRRef AND _AccntRegED1852_TED1._LineNo = _AccntReg1832_R._LineNo AND _AccntRegED1852_TED1._Period = _AccntReg1832_R._Period AND _AccntRegED1852_TED1._KindRRef = _Acc2_ExtDim1799_TEDAcc1._DimKindRRef LEFT OUTER JOIN _Acc2_ExtDim1799 _Acc2_ExtDim1799_TEDAcc2 ON _Acc2_ExtDim1799_TEDAcc2._Acc2_IDRRef = _AccntReg1832_R._AccountRRef AND _Acc2_ExtDim1799_TEDAcc2._LineNo = 2 LEFT OUTER JOIN _AccntRegED1852 _AccntRegED1852_TED2 ON _AccntRegED1852_TED2._RecorderTRef = _AccntReg1832_R._RecorderTRef AND _AccntRegED1852_TED2._RecorderRRef = _AccntReg1832_R._RecorderRRef AND _AccntRegED1852_TED2._LineNo = _AccntReg1832_R._LineNo AND _AccntRegED1852_TED2._Period = _AccntReg1832_R._Period AND _AccntRegED1852_TED2._KindRRef = _Acc2_ExtDim1799_TEDAcc2._DimKindRRef WHERE _AccntReg1832_R._Active = TRUE AND _AccntReg1832_R._AccountRRef = '\\227\\177\\233\\021Y\\310X\\205Ov"\\263\\377h{\\227'::bytea AND _AccntRegED1852_TED1._Value_TYPE = '\\010'::bytea AND _AccntRegED1852_TED1._Value_RTRef = '\\000\\000\\000\\006'::bytea AND _AccntRegED1852_TED1._Value_RRRef = '\\252F\\0000HuM"\\021\\333ti\\002C\\245\\357'::bytea AND _AccntReg1832_R._Fld1833RRef = '\\257\\327\\0000HuM#\\021\\332<\\316\\305\\006\\344\\231'::bytea AND _AccntReg1832_R._Period >= '2008-05-20 23:59:59'::timestamp AND _AccntReg1832_R._Period < '3999-11-01 00:00:00'::timestamp) ) _V8TblAli1_R GROUP BY _V8TblAli1_R._Value2_TYPE, _V8TblAli1_R._Value2_S, _V8TblAli1_R._Value2_RTRef, _V8TblAli1_R._Value2_RRRef HAVING CASE WHEN SUM(_V8TblAli1_R._Fld1837Balance) IS NULL THEN CAST(0 AS NUMERIC(28,3)) ELSE SUM(_V8TblAli1_R._Fld1837Balance) END <> 0 ) _V8TblAli2_Q_000_T_005 ON _V8TblAli2_Q_000_T_005._Value2_TYPE = '\\010'::bytea AND _V8TblAli2_Q_000_T_005._Value2_RTRef = '\\000\\000\\000\\013'::bytea AND _Reference11_Q_000_T_001._IDRRef = _V8TblAli2_Q_000_T_005._Value2_RRRef WHERE NOT _Reference11_Q_000_T_001._IDRRef IN (SELECT tt1._IDRRef AS f_1 FROM tt1) AND _Reference13_Q_000_T_002._Marked = FALSE AND _Reference11_Q_000_T_001._Marked = FALSE AND _V8TblAli1_Q_000_T_003._Fld1563 > 0 ORDER BY _Reference11_Q_000_T_001._Description;
взято отсюда:
http://forum.postgresqlrussia.org/viewtopi...ic.php?f=2&t=40
