File: q5

package info (click to toggle)
sqlreduce 1.3-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 12,172 kB
  • sloc: python: 1,026; sql: 40; sh: 22; makefile: 14
file content (19 lines) | stat: -rw-r--r-- 918 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
select  
	  (select fdwacl from pg_catalog.pg_foreign_data_wrapper limit 1 offset 36)
	     as c0, 
	  
	    pg_catalog.bit_xor(
	      cast(73 as int4)) over (partition by sample_0.amopmethod order by sample_0.amopfamily) as c1
	from 
	  pg_catalog.pg_amop as sample_0 tablesample system (8) 
	    left join pg_catalog.pg_sequence as ref_0
	    on ((select pid from pg_catalog.pg_stat_progress_analyze limit 1 offset 3)
	           >= sample_0.amopstrategy)
	where pg_catalog.circle_sub_pt(
	    cast(cast(null as circle) as circle),
	    cast(case when (select transaction from pg_catalog.pg_prepared_xacts limit 1 offset 3)
	           = (select pg_catalog.bit_and(rolconnlimit) from pg_catalog.pg_roles)
	           then cast(null as point) else cast(null as point) end
	       as point)) >> pg_catalog.circle_in(
	    cast(cast(nullif(cast(null as cstring),
	      cast(null as cstring)) as cstring) as cstring))