===========================================================
                                      .___ __  __   
          _________________  __ __  __| _/|__|/  |_ 
         / ___\_` __ \__  \ |  |  \/ __ | | \\_  __\
        / /_/  >  | \// __ \|  |  / /_/ | |  ||  |  
        \___  /|__|  (____  /____/\____ | |__||__|  
       /_____/            \/           \/           
              grep rough audit - static analysis tool
                  v2.8 written by @Wireghoul
=================================[justanotherhacker.com]===
pgformatter-4.4/t/02_regress.t-5-
pgformatter-4.4/t/02_regress.t:6:my $ret = `perl -I. -wc $pg_format 2>&1`;
pgformatter-4.4/t/02_regress.t-7-ok( $? == 0, "$pg_format compiles OK" ) or exit $?;
##############################################
pgformatter-4.4/t/02_regress.t-31-	my $cmd = "$pg_format $opt -u 2 -X $f >/tmp/output.sql";
pgformatter-4.4/t/02_regress.t:32:	`$cmd`;
pgformatter-4.4/t/02_regress.t-33-	$f =~ s/test-files\//test-files\/expected\//;
pgformatter-4.4/t/02_regress.t-34-	if (lc($ARGV[0]) eq 'update') {
pgformatter-4.4/t/02_regress.t:35:		`cp -f /tmp/output.sql $f`;
pgformatter-4.4/t/02_regress.t-36-	} else { 
pgformatter-4.4/t/02_regress.t:37:		my @diff = `diff -u /tmp/output.sql $f | grep "^[+-]" | grep -v "^[+-]\t\$" | grep -v "^[+-][+-][+-]"`;
pgformatter-4.4/t/02_regress.t-38-		ok( $#diff < 0, "Test file $f");
##############################################
pgformatter-4.4/t/pg-test-files/expected/hash_func.sql-181-    v AS value,
pgformatter-4.4/t/pg-test-files/expected/hash_func.sql:182:    hashmacaddr(v)::bit(32) AS standard,
pgformatter-4.4/t/pg-test-files/expected/hash_func.sql-183-    hashmacaddrextended(v, 0)::bit(32) AS extended0,
##############################################
pgformatter-4.4/t/pg-test-files/expected/hash_func.sql-192-WHERE
pgformatter-4.4/t/pg-test-files/expected/hash_func.sql:193:    hashmacaddr(v)::bit(32) != hashmacaddrextended(v, 0)::bit(32)
pgformatter-4.4/t/pg-test-files/expected/hash_func.sql:194:        OR hashmacaddr(v)::bit(32) = hashmacaddrextended(v, 1)::bit(32);
pgformatter-4.4/t/pg-test-files/expected/hash_func.sql-195-
##############################################
pgformatter-4.4/t/pg-test-files/expected/plpgsql.sql-3707-    -- no rows
pgformatter-4.4/t/pg-test-files/expected/plpgsql.sql:3708:    EXECUTE 'select * from foo where f1 = $1 or f1::text = $2'
pgformatter-4.4/t/pg-test-files/expected/plpgsql.sql-3709-    USING 0,
##############################################
pgformatter-4.4/t/pg-test-files/expected/privileges.sql-1311-    RETURNS text
pgformatter-4.4/t/pg-test-files/expected/privileges.sql:1312:    AS 'select col1 from atest2 where col2 = $1;'
pgformatter-4.4/t/pg-test-files/expected/privileges.sql-1313-    LANGUAGE sql
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-16-    RETURNS SETOF rngfunc2
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:17:    AS 'SELECT * FROM rngfunc2 WHERE rngfuncid = $1 ORDER BY f2;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-18-    LANGUAGE SQL;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-396-    RETURNS SETOF int
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:397:    AS 'SELECT rngfuncid FROM rngfunc WHERE rngfuncid = $1;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-398-    LANGUAGE SQL;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-440-    RETURNS SETOF text
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:441:    AS 'SELECT rngfuncname FROM rngfunc WHERE rngfuncid = $1;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-442-    LANGUAGE SQL;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-484-    RETURNS rngfunc
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:485:    AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-486-    LANGUAGE SQL;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-528-    RETURNS SETOF rngfunc
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:529:    AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-530-    LANGUAGE SQL;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-572-    RETURNS RECORD
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:573:    AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-574-    LANGUAGE SQL;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-621-    RETURNS SETOF record
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:622:    AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-623-    LANGUAGE SQL;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-670-    RETURNS int
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:671:    AS 'DECLARE rngfuncint int; BEGIN SELECT rngfuncid into rngfuncint FROM rngfunc WHERE rngfuncid = $1; RETURN rngfuncint; END;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-672-    LANGUAGE plpgsql;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-714-    RETURNS rngfunc
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:715:    AS 'DECLARE rngfunctup rngfunc%ROWTYPE; BEGIN SELECT * into rngfunctup FROM rngfunc WHERE rngfuncid = $1; RETURN rngfunctup; END;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-716-    LANGUAGE plpgsql;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rules.sql-1169-    RETURNS int4
pgformatter-4.4/t/pg-test-files/expected/rules.sql:1170:    AS 'select count(*)::int4 from rtest_view2 where a = $1'
pgformatter-4.4/t/pg-test-files/expected/rules.sql-1171-    LANGUAGE sql;
##############################################
pgformatter-4.4/t/pg-test-files/sql/hash_func.sql-89-
pgformatter-4.4/t/pg-test-files/sql/hash_func.sql:90:SELECT v as value, hashmacaddr(v)::bit(32) as standard,
pgformatter-4.4/t/pg-test-files/sql/hash_func.sql-91-	   hashmacaddrextended(v, 0)::bit(32) as extended0,
##############################################
pgformatter-4.4/t/pg-test-files/sql/hash_func.sql-95-        ('ea:29:b1:5e:1f:a5')) x(v)
pgformatter-4.4/t/pg-test-files/sql/hash_func.sql:96:WHERE  hashmacaddr(v)::bit(32) != hashmacaddrextended(v, 0)::bit(32)
pgformatter-4.4/t/pg-test-files/sql/hash_func.sql:97:       OR hashmacaddr(v)::bit(32) = hashmacaddrextended(v, 1)::bit(32);
pgformatter-4.4/t/pg-test-files/sql/hash_func.sql-98-
##############################################
pgformatter-4.4/t/pg-test-files/sql/hs_standby_allowed.sql-97-PREPARE hsp AS select count(*) from hs1;
pgformatter-4.4/t/pg-test-files/sql/hs_standby_allowed.sql:98:PREPARE hsp_noexec (integer) AS insert into hs1 values ($1);
pgformatter-4.4/t/pg-test-files/sql/hs_standby_allowed.sql-99-
##############################################
pgformatter-4.4/t/pg-test-files/sql/join.sql-667-    on (a.unique2 = b.unique1 and exists
pgformatter-4.4/t/pg-test-files/sql/join.sql:668:        (select 1 from tenk1 c where c.thousand = b.unique2 and $1));
pgformatter-4.4/t/pg-test-files/sql/join.sql-669-execute foo(true);
##############################################
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql-743-SELECT count(*) FROM testjsonb WHERE j @@ '$.wait == null';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql:744:SELECT count(*) FROM testjsonb WHERE j @@ '"CC" == $.wait';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql:745:SELECT count(*) FROM testjsonb WHERE j @@ '$.wait == "CC" && true == $.public';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql-746-SELECT count(*) FROM testjsonb WHERE j @@ '$.age == 25';
##############################################
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql-783-SELECT count(*) FROM testjsonb WHERE j @@ 'exists($.wait ? (@ == null))';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql:784:SELECT count(*) FROM testjsonb WHERE j @@ '"CC" == $.wait';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql:785:SELECT count(*) FROM testjsonb WHERE j @@ '$.wait == "CC" && true == $.public';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql-786-SELECT count(*) FROM testjsonb WHERE j @@ '$.age == 25';
##############################################
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql-863-SELECT count(*) FROM testjsonb WHERE j @@ 'exists($.wait ? (@ == null))';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql:864:SELECT count(*) FROM testjsonb WHERE j @@ '"CC" == $.wait';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql:865:SELECT count(*) FROM testjsonb WHERE j @@ '$.wait == "CC" && true == $.public';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql-866-SELECT count(*) FROM testjsonb WHERE j @@ '$.age == 25';
##############################################
pgformatter-4.4/t/pg-test-files/sql/opr_sanity.sql-40-  if $2 = 'pg_catalog.anyrange'::pg_catalog.regtype then
pgformatter-4.4/t/pg-test-files/sql/opr_sanity.sql:41:    if (select typtype from pg_catalog.pg_type where oid = $1) = 'r'
pgformatter-4.4/t/pg-test-files/sql/opr_sanity.sql-42-    then return true; end if;
##############################################
pgformatter-4.4/t/pg-test-files/sql/opr_sanity.sql-65-  if $2 = 'pg_catalog.anyrange'::pg_catalog.regtype then
pgformatter-4.4/t/pg-test-files/sql/opr_sanity.sql:66:    if (select typtype from pg_catalog.pg_type where oid = $1) = 'r'
pgformatter-4.4/t/pg-test-files/sql/opr_sanity.sql-67-    then return true; end if;
##############################################
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-334-prepare ab_q1 (int, int, int) as
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql:335:select * from ab where a between $1 and $2 and b <= $3;
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-336-
##############################################
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-565-	select tableoid::regclass,a,b from ab
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql:566:) ab where a = $1 and b = (select -10);
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-567-
##############################################
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-687-prepare part_abc_q1 (int, int, int) as
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql:688:select * from part_abc where a = $1 and b = $2 and c = $3;
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-689-
##############################################
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-785-analyze ma_test;
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql:786:prepare mt_q1 (int) as select a from ma_test where a >= $1 and a % 10 = 5 order by b;
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-787-
##############################################
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-972-     ) s(a, b, c)
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql:973:where s.a = $1 and s.b = $2 and s.c = (select 1);
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-974-
##############################################
pgformatter-4.4/t/pg-test-files/sql/plancache.sql-12--- and one with parameters
pgformatter-4.4/t/pg-test-files/sql/plancache.sql:13:PREPARE prepstmt2(bigint) AS SELECT * FROM pcachetest WHERE q1 = $1;
pgformatter-4.4/t/pg-test-files/sql/plancache.sql-14-
##############################################
pgformatter-4.4/t/pg-test-files/sql/plancache.sql-187-
pgformatter-4.4/t/pg-test-files/sql/plancache.sql:188:prepare test_mode_pp (int) as select count(*) from test_mode where a = $1;
pgformatter-4.4/t/pg-test-files/sql/plancache.sql-189-
##############################################
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-1016-begin
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql:1017:    select into rec * from PSlot where slotname = $1;
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-1018-    if not found then
##############################################
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-1060-begin
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql:1061:    select into psrec * from PSlot where slotname = $1;
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-1062-    if not found then
##############################################
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-1096-begin
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql:1097:    select into rec * from WSlot where slotname = $1;
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-1098-    if not found then
##############################################
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-2304-  -- no rows
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql:2305:  execute 'select * from foo where f1 = $1 or f1::text = $2' using 0, 'foo' into strict x;
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-2306-  raise notice 'x.f1 = %, x.f2 = %', x.f1, x.f2;
##############################################
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-3473-create function error1(text) returns text language sql as
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql:3474:$$ SELECT relname::text FROM pg_class c WHERE c.oid = $1::regclass $$;
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-3475-
##############################################
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-34-	SELECT datname, datistemplate, datallowconn
pgformatter-4.4/t/pg-test-files/sql/prepare.sql:35:	FROM pg_database WHERE datname = $1;
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-36-
##############################################
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-39-PREPARE q3(text, int, float, boolean, smallint) AS
pgformatter-4.4/t/pg-test-files/sql/prepare.sql:40:	SELECT * FROM tenk1 WHERE string4 = $1 AND (four = $2 OR
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-41-	ten = $3::bigint OR true = $4 OR odd = $5::int)
##############################################
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-59-PREPARE q5(int, text) AS
pgformatter-4.4/t/pg-test-files/sql/prepare.sql:60:	SELECT * FROM tenk1 WHERE unique1 = $1 OR stringu1 = $2
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-61-	ORDER BY unique1;
##############################################
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-69-PREPARE q6 AS
pgformatter-4.4/t/pg-test-files/sql/prepare.sql:70:    SELECT * FROM tenk1 WHERE unique1 = $1 AND stringu1 = $2;
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-71-PREPARE q7(unknown) AS
pgformatter-4.4/t/pg-test-files/sql/prepare.sql:72:    SELECT * FROM road WHERE thepath = $1;
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-73-
##############################################
pgformatter-4.4/t/pg-test-files/sql/privileges.sql-448-CREATE FUNCTION priv_testfunc4(boolean) RETURNS text
pgformatter-4.4/t/pg-test-files/sql/privileges.sql:449:  AS 'select col1 from atest2 where col2 = $1;'
pgformatter-4.4/t/pg-test-files/sql/privileges.sql-450-  LANGUAGE sql SECURITY DEFINER;
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-5-
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:6:CREATE FUNCTION rngfunct(int) returns setof rngfunc2 as 'SELECT * FROM rngfunc2 WHERE rngfuncid = $1 ORDER BY f2;' LANGUAGE SQL;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-7-
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-101--- sql, proretset = t, prorettype = b
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:102:CREATE FUNCTION getrngfunc2(int) RETURNS setof int AS 'SELECT rngfuncid FROM rngfunc WHERE rngfuncid = $1;' LANGUAGE SQL;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-103-SELECT * FROM getrngfunc2(1) AS t1;
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-112--- sql, proretset = t, prorettype = b
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:113:CREATE FUNCTION getrngfunc3(int) RETURNS setof text AS 'SELECT rngfuncname FROM rngfunc WHERE rngfuncid = $1;' LANGUAGE SQL;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-114-SELECT * FROM getrngfunc3(1) AS t1;
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-123--- sql, proretset = f, prorettype = c
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:124:CREATE FUNCTION getrngfunc4(int) RETURNS rngfunc AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;' LANGUAGE SQL;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-125-SELECT * FROM getrngfunc4(1) AS t1;
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-134--- sql, proretset = t, prorettype = c
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:135:CREATE FUNCTION getrngfunc5(int) RETURNS setof rngfunc AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;' LANGUAGE SQL;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-136-SELECT * FROM getrngfunc5(1) AS t1;
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-145--- sql, proretset = f, prorettype = record
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:146:CREATE FUNCTION getrngfunc6(int) RETURNS RECORD AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;' LANGUAGE SQL;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-147-SELECT * FROM getrngfunc6(1) AS t1(rngfuncid int, rngfuncsubid int, rngfuncname text);
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-159--- sql, proretset = t, prorettype = record
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:160:CREATE FUNCTION getrngfunc7(int) RETURNS setof record AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;' LANGUAGE SQL;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-161-SELECT * FROM getrngfunc7(1) AS t1(rngfuncid int, rngfuncsubid int, rngfuncname text);
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-173--- plpgsql, proretset = f, prorettype = b
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:174:CREATE FUNCTION getrngfunc8(int) RETURNS int AS 'DECLARE rngfuncint int; BEGIN SELECT rngfuncid into rngfuncint FROM rngfunc WHERE rngfuncid = $1; RETURN rngfuncint; END;' LANGUAGE plpgsql;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-175-SELECT * FROM getrngfunc8(1) AS t1;
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-184--- plpgsql, proretset = f, prorettype = c
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:185:CREATE FUNCTION getrngfunc9(int) RETURNS rngfunc AS 'DECLARE rngfunctup rngfunc%ROWTYPE; BEGIN SELECT * into rngfunctup FROM rngfunc WHERE rngfuncid = $1; RETURN rngfunctup; END;' LANGUAGE plpgsql;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-186-SELECT * FROM getrngfunc9(1) AS t1;
##############################################
pgformatter-4.4/t/pg-test-files/sql/rowsecurity.sql-559--- prepared statement with regress_rls_alice privilege
pgformatter-4.4/t/pg-test-files/sql/rowsecurity.sql:560:PREPARE p1(int) AS SELECT * FROM t1 WHERE a <= $1;
pgformatter-4.4/t/pg-test-files/sql/rowsecurity.sql-561-EXECUTE p1(2);
##############################################
pgformatter-4.4/t/pg-test-files/sql/rowsecurity.sql-573-
pgformatter-4.4/t/pg-test-files/sql/rowsecurity.sql:574:PREPARE p2(int) AS SELECT * FROM t1 WHERE a = $1;
pgformatter-4.4/t/pg-test-files/sql/rowsecurity.sql-575-EXECUTE p2(2);
##############################################
pgformatter-4.4/t/pg-test-files/sql/rules.sql-432-create function rtest_viewfunc1(int4) returns int4 as
pgformatter-4.4/t/pg-test-files/sql/rules.sql:433:	'select count(*)::int4 from rtest_view2 where a = $1'
pgformatter-4.4/t/pg-test-files/sql/rules.sql-434-	language sql;
##############################################
pgformatter-4.4/t/pg-test-files/sql/select_parallel.sql-423-
pgformatter-4.4/t/pg-test-files/sql/select_parallel.sql:424:PREPARE pstmt(text, int[]) AS SELECT * FROM fooarr WHERE f1 = $1 AND f2 = $2;
pgformatter-4.4/t/pg-test-files/sql/select_parallel.sql-425-EXPLAIN (COSTS OFF) EXECUTE pstmt('1', make_some_array(1,2));
##############################################
pgformatter-4.4/t/regress_test.pl-30-	my $cmd = "./pg_format $opt -u 2 $f >/tmp/output.sql";
pgformatter-4.4/t/regress_test.pl:31:	`$cmd`;
pgformatter-4.4/t/regress_test.pl-32-	$f =~ s/test-files\//test-files\/expected\//;
pgformatter-4.4/t/regress_test.pl-33-	if (lc($ARGV[0]) eq 'update') {
pgformatter-4.4/t/regress_test.pl:34:		`cp -f /tmp/output.sql $f`;
pgformatter-4.4/t/regress_test.pl-35-	} else { 
pgformatter-4.4/t/regress_test.pl:36:		my @diff = `diff -u /tmp/output.sql $f | grep "^[+-]" | grep -v "^[+-]\t\$" | grep -v "^[+-][+-][+-]"`;
pgformatter-4.4/t/regress_test.pl-37-		if ($#diff < 0) {
##############################################
pgformatter-4.4/t/regress_test.pl-57-	my $cmd = "./pg_format $opt -u 2 $f >/tmp/output.sql";
pgformatter-4.4/t/regress_test.pl:58:	`$cmd`;
pgformatter-4.4/t/regress_test.pl-59-	$f =~ s/\/sql\//\/expected\//;
pgformatter-4.4/t/regress_test.pl-60-	if (lc($ARGV[0]) eq 'update') {
pgformatter-4.4/t/regress_test.pl:61:		`cp -f /tmp/output.sql $f`;
pgformatter-4.4/t/regress_test.pl-62-	} else { 
pgformatter-4.4/t/regress_test.pl:63:		my @diff = `diff -u /tmp/output.sql $f | grep "^[+-]" | grep -v "^[+-]\$" | grep -v "^[+-]\t\$" | grep -v "^[+-][+-][+-]"`;
pgformatter-4.4/t/regress_test.pl-64-		if ($#diff < 0) {
##############################################
pgformatter-4.4/t/test-files/ex17.sql-55-        FROM    pwds
pgformatter-4.4/t/test-files/ex17.sql:56:        WHERE   username = $1;
pgformatter-4.4/t/test-files/ex17.sql-57-
##############################################
pgformatter-4.4/t/test-files/ex19.sql-23-                                pg_index on (pg_class.oid = pg_index.indrelid and attnum = any (indkey))
pgformatter-4.4/t/test-files/ex19.sql:24:                          WHERE pg_class.oid = '$f$ || $1 || $f$ '::regclass and indisprimary $f$
pgformatter-4.4/t/test-files/ex19.sql-25-  LOOP
##############################################
pgformatter-4.4/t/test-files/ex19.sql-63-                 FROM pg_attribute JOIN pg_class on (oid=attrelid)
pgformatter-4.4/t/test-files/ex19.sql:64:                 WHERE pg_class.oid = $1::regclass and attlen = -1
pgformatter-4.4/t/test-files/ex19.sql-65-   LOOP
##############################################
pgformatter-4.4/t/test-files/ex27.sql:1:SELECT opgt.part_id, opgt.art_id, rGpe.slot_id, rGpe.grp_art_id FROM ( SELECT id, part_product_kind_id FROM part_product ldm WHERE nb_colis > 0 AND statut_part_product IN ('DISPATCH','CANCELED','SALE_PROD') AND ldm.art_frect_id IS NULL AND NOT EXISTS ( SELECT subparts.id FROM part_product subparts WHERE ldm.id = subparts.part_product_parent_id )) ldm JOIN LATERAL ( SELECT opgt.id, part.id as part_id, opgt.art_id FROM part_product part JOIN part_product_kind opgt ON opgt.id = part.part_product_kind_id WHERE part.id = ldm.id AND opgt.plateforme_distribution_id = ($1) AND opgt.day_export_shop_id IN ( SELECT id FROM day_export_shop jem WHERE day <= to_timestamp($2) AND day > current_date - interval '4 mons')) opgt ON true JOIN LATERAL (SELECT r.id AS slot_id, ga.id AS grp_art_id FROM part_product_kind lm JOIN art a ON a.id = lm.art_id JOIN grp_art ga ON ga.id = a.grp_art_id JOIN slot r ON r.id = ga.slot_id WHERE opgt.id = lm.id) rGpe ON true UNION SELECT opgt.part_id, opgt.art_id, rGpe.slot_id, rGpe.grp_art_id FROM ( SELECT id, art_frect_id, part_product_kind_id FROM part_product ldm WHERE nb_colis > 0 AND statut_part_product IN ('DISPATCH','CANCELED','SALE_PROD') AND art_frect_id IS NOT NULL AND NOT EXISTS ( SELECT subparts.id FROM part_product subparts WHERE ldm.id = subparts.part_product_parent_id )) ldm JOIN LATERAL ( SELECT opgt.id, part.id as part_id, opgt.art_id FROM part_product part JOIN part_product_kind opgt ON opgt.id = part.part_product_kind_id WHERE part.id = ldm.id AND opgt.plateforme_distribution_id = ($3) AND opgt.day_export_shop_id IN ( SELECT id FROM day_export_shop jem WHERE day <= to_timestamp($4) AND day > current_date - interval '4 mons')) opgt ON true JOIN LATERAL (SELECT r.id AS slot_id, ga.id AS grp_art_id FROM part_product lm JOIN art a ON a.id = lm.art_frect_id JOIN grp_art ga ON ga.id = a.grp_art_id JOIN slot r ON r.id = ga.slot_id WHERE opgt.id = lm.id) rGpe ON true;
pgformatter-4.4/t/test-files/ex27.sql-2-
##############################################
pgformatter-4.4/t/test-files/ex53.sql-170--- original snippet
pgformatter-4.4/t/test-files/ex53.sql:171:\set user `echo $PGRST_DB_USER`
pgformatter-4.4/t/test-files/ex53.sql:172:\set passwd `echo $PGRST_DB_PWD`
pgformatter-4.4/t/test-files/ex53.sql-173-CREATE ROLE :user WITH LOGIN noinherit PASSWORD :'passwd';
##############################################
pgformatter-4.4/t/test-files/expected/ex19.sql-24-                                pg_index on (pg_class.oid = pg_index.indrelid and attnum = any (indkey))
pgformatter-4.4/t/test-files/expected/ex19.sql:25:                          WHERE pg_class.oid = '$f$ || $1 || $f$ '::regclass and indisprimary $f$ LOOP
pgformatter-4.4/t/test-files/expected/ex19.sql-26-        IF pkcols = '' THEN
##############################################
pgformatter-4.4/t/test-files/expected/ex53.sql-236--- original snippet
pgformatter-4.4/t/test-files/expected/ex53.sql:237:\set user `echo $PGRST_DB_USER`
pgformatter-4.4/t/test-files/expected/ex53.sql:238:\set passwd `echo $PGRST_DB_PWD`
pgformatter-4.4/t/test-files/expected/ex53.sql-239-CREATE ROLE :user WITH LOGIN noinherit PASSWORD :'passwd';