fork download
copy 
  1. import re
  2. pat = r"COALESCE\((.*?)\)"
  3. s = "select DISTINCT SUM(case when t0_0.pp is not null  then COALESCE(t0_0.pp,0)\nelse 0 end) from inventory_coverage_view t0_0 where  LOWER(t0_0.h) ='vg' AND t0_0.id = '9'"
  4. m = re.search(pat, s)
  5. if m:
  6. 	print(m.group(1))
  7.  
Success #stdin #stdout 0.01s 23304KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
t0_0.pp,0
https://ideone.com/6ARXYz
language:
Python (cpython 2.7.16)
created:
8 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!