Paste #140175
   
Operation paste
pasted on 04.08.2020 20:53
  • Edit to this paste
  • Print
  • Raw
  • Compare it with the parent paste
  • Look at the parent paste
  • The following pastes replied to this paste:  # 140255 # 142265 # 277442
  • Show paste tree
  • Compare with paste
    #  
  • Toggle line numbers
  • Syntax highlighting  
Text paste 
1
SELECT T1._Q_001_F_000RRef, T1._Q_001_F_001, T2._Q_000_F_000_TYPE, T2._Q_000_F_000_RTRef, T2._Q_000_F_000_RRRef, T2._Q_000_F_002, COALESCE(CAST(T3._Q_001_F_001 AS NUMERIC(3, 0)), CAST(0 AS NUMERIC)), COALESCE(CAST(T3._Q_001_F_002 AS NUMERIC(15, 2)), CAST(0 AS NUMERIC)), CASE WHEN T2._Q_000_F_000_TYPE = '\\010'::bytea AND T2._Q_000_F_000_RTRef = '\\000\\000\\001\\270'::bytea THEN T4._Date_Time WHEN T2._Q_000_F_000_TYPE = '\\010'::bytea AND T2._Q_000_F_000_RTRef = '\\000\\000_*'::bytea THEN T5._Date_Time WHEN T2._Q_000_F_000_TYPE = '\\010'::bytea AND T2._Q_000_F_000_RTRef = '\\000\\000\\001\\257'::bytea THEN T6._Date_Time WHEN T2._Q_000_F_000_TYPE = '\\010'::bytea AND T2._Q_000_F_000_RTRef = '\\000\\000\\001['::bytea THEN T7._Date_Time WHEN T2._Q_000_F_000_TYPE = '\\010'::bytea AND T2._Q_000_F_000_RTRef = '\\000\\000\\001\\255'::bytea THEN T8._Date_Time WHEN T2._Q_000_F_000_TYPE = '\\010'::bytea AND T2._Q_000_F_000_RTRef = '\\000\\000\\001\\211'::bytea THEN T9._Date_Time WHEN T2._Q_000_F_000_TYPE = '\\010'::bytea AND T2._Q_000_F_000_RTRef = '\\000\\000\\001\\323'::bytea THEN T10._Date_Time WHEN T2._Q_000_F_000_TYPE = '\\010'::bytea AND T2._Q_000_F_000_RTRef = '\\000\\000\\001\\226'::bytea THEN T11._Date_Time WHEN T2._Q_000_F_000_TYPE = '\\010'::bytea AND T2._Q_000_F_000_RTRef = '\\000\\000\\001j'::bytea THEN T12._Date_Time WHEN T2._Q_000_F_000_TYPE = '\\010'::bytea AND T2._Q_000_F_000_RTRef = '\\000\\000\\001\\\::byte[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 305 '::bytea THEN T14._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 212 '::bytea THEN T15._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000[= '::bytea THEN T16._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001T '::bytea THEN T17._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 200 '::bytea THEN T18._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 233 '::bytea THEN T19._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001n '::bytea THEN T20._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 230 '::bytea THEN T21._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 275 '::bytea THEN T22._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 242 '::bytea THEN T23._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000_A '::bytea THEN T24._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 177 '::bytea THEN T25._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 274 '::bytea THEN T26._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000[> '::bytea THEN T27._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001J '::bytea THEN T28._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 234 '::bytea THEN T29._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 ~ '::bytea THEN T30._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 231 '::bytea THEN T31._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001_ '::bytea THEN T32._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 256 '::bytea THEN T33._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000[: '::bytea THEN T34._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001K '::bytea THEN T35._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 306 '::bytea THEN T36._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001Z '::bytea THEN T37._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001a '::bytea THEN T38._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 227 '::bytea THEN T39._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 240 '::bytea THEN T40._Date_T[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 `'::bytea THEN T41._Date_T[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001U'::bytea THEN T42._Date_T[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001p'::bytea THEN T43._Date_T[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\273'::bytea THEN T44._Date_T[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001f'::bytea THEN T45._Date_T[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\254'::bytea THEN T46._Date_T[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000[A'::bytea THEN T47._Date_T[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\270'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\270'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000_*'::bytea THEN CASE WHEN T[...]'\\000\\000_*'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\257'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\257'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001['::bytea THEN CASE WHEN T[...]'\\000\\000\\001['::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\255'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\255'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\211'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\211'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\323'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\323'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\226'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\226'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001j'::bytea THEN CASE WHEN T[...]'\\000\\000\\001j'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\\::bytea THEN CASE WHEN T13._IDRRef IS NOT NULL THEN '\\000\\000\\001\\\::byte[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\305'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\305'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\212'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\212'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000[='::bytea THEN CASE WHEN T[...]'\\000\\000[='::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001T'::bytea THEN CASE WHEN T[...]'\\000\\000\\001T'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\200'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\200'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\233'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\233'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001n'::bytea THEN CASE WHEN T[...]'\\000\\000\\001n'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\230'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\230'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\275'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\275'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\242'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\242'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000_A'::bytea THEN CASE WHEN T[...]'\\000\\000_A'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\177'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\177'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\274'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\274'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000[>'::bytea THEN CASE WHEN T[...]'\\000\\000[>'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001J'::bytea THEN CASE WHEN T[...]'\\000\\000\\001J'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\234'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\234'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001~'::bytea THEN CASE WHEN T[...]'\\000\\000\\001~'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\231'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\231'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001_'::bytea THEN CASE WHEN T[...]'\\000\\000\\001_'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\256'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\256'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000[:'::bytea THEN CASE WHEN T[...]'\\000\\000[:'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001K'::bytea THEN CASE WHEN T[...]'\\000\\000\\001K'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\306'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\306'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001Z'::bytea THEN CASE WHEN T[...]'\\000\\000\\001Z'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001a'::bytea THEN CASE WHEN T[...]'\\000\\000\\001a'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\227'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\227'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001\\240'::bytea THEN CASE WHEN T[...]'\\000\\000\\001\\240'::bytea END WHEN T2._Q_0[...]'\\010'::bytea AND T2._Q_000_F_[...]'\\000\\000\\001` '::bytea THEN CASE WHEN T[...]' 000 000 001 '::bytea END WHEN T2._Q_0[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001U '::bytea THEN CASE WHEN T[...]' 000 000 001U '::bytea END WHEN T2._Q_0[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001p '::bytea THEN CASE WHEN T[...]' 000 000 001p '::bytea END WHEN T2._Q_0[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 273 '::bytea THEN CASE WHEN T[...]' 000 000 001 273 '::bytea END WHEN T2._Q_0[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001f '::bytea THEN CASE WHEN T[...]' 000 000 001f '::bytea END WHEN T2._Q_0[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 254 '::bytea THEN CASE WHEN T[...]' 000 000 001 254 '::bytea END WHEN T2._Q_0[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000[A '::bytea THEN CASE WHEN T[...]' 000 000[A '::bytea END ELSE CAST(NU[...]' 010 '::bytea AND T2._Q_000_F_[...]' 000 000 001 27[...];
Add Comment
Author