| /dports/biology/mmseqs2/MMseqs2-13-45111/lib/tinyexpr/ |
| H A D | README.md | 186 double my_sum(double a, double b) {
192 {"mysum", my_sum, TE_FUNCTION2} /* TE_FUNCTION2 used because my_sum takes two arguments. */
|
| H A D | example3.c | 6 double my_sum(double a, double b) { in my_sum() function
15 {"mysum", my_sum, TE_FUNCTION2} in main()
|
| /dports/databases/p5-DBD-SQLite/DBD-SQLite-1.70/t/ |
| H A D | 09_create_function.t | 27 sub my_sum {
85 ok($dbh->$call_func( "my_sum", -1, \&my_sum, defined $flags ? $flags : (), "create_function" ));
86 $result = $dbh->selectrow_arrayref( "SELECT my_sum( '2', 3, 4, '5')" );
87 is( $result->[0], 14, "SELECT my_sum( '2', 3, 4, '5')" );
|
| /dports/databases/p5-DBD-SQLite2/DBD-SQLite2-0.38/t/ |
| H A D | 08create_function.t | 15 sub my_sum {
65 $dbh->func( "my_sum", -1, \&my_sum, "create_function" );
66 $result = $dbh->selectrow_arrayref( "SELECT my_sum( '2', 3, 4, '5')" );
|
| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
| H A D | aggregates.sql | 1967 CREATE AGGREGATE my_sum (int4) (
1982 my_sum (one)
1989 my_sum (DISTINCT one)
1997 my_sum (one)
2004 my_sum (one)
2011 my_sum (two)
2112 CREATE AGGREGATE my_sum (int4) (
2123 my_sum (one),
|
| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
| H A D | aggregates.sql | 751 create aggregate my_sum(int4)
762 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
765 select my_avg(distinct one),my_sum(distinct one) from (values(1),(3),(1)) t(one);
768 select my_avg(distinct one),my_sum(one) from (values(1),(3)) t(one);
771 select my_avg(one) filter (where one > 1),my_sum(one) from (values(1),(3)) t(one);
774 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
861 create aggregate my_sum(int4)
875 select my_sum(one),my_half_sum(one) from (values(1),(2),(3),(4)) t(one);
|
| /dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/expected/ |
| H A D | aggregates.out | 1856 create aggregate my_sum(int4)
1872 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
1875 my_avg | my_sum
1884 my_avg | my_sum
1895 my_avg | my_sum
1905 my_avg | my_sum
1911 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
1916 my_avg | my_sum
2015 create aggregate my_sum(int4)
2026 -- Agg state should be shared even though my_sum has no finalfn
[all …]
|
| /dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
| H A D | aggregates.sql | 738 create aggregate my_sum(int4)
749 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
752 select my_avg(distinct one),my_sum(distinct one) from (values(1),(3),(1)) t(one);
755 select my_avg(distinct one),my_sum(one) from (values(1),(3)) t(one);
758 select my_avg(one) filter (where one > 1),my_sum(one) from (values(1),(3)) t(one);
761 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
842 create aggregate my_sum(int4)
856 select my_sum(one),my_half_sum(one) from (values(1),(2),(3),(4)) t(one);
|
| /dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/expected/ |
| H A D | aggregates.out | 1856 create aggregate my_sum(int4)
1872 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
1875 my_avg | my_sum
1884 my_avg | my_sum
1895 my_avg | my_sum
1905 my_avg | my_sum
1911 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
1916 my_avg | my_sum
2015 create aggregate my_sum(int4)
2026 -- Agg state should be shared even though my_sum has no finalfn
[all …]
|
| /dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
| H A D | aggregates.sql | 738 create aggregate my_sum(int4)
749 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
752 select my_avg(distinct one),my_sum(distinct one) from (values(1),(3),(1)) t(one);
755 select my_avg(distinct one),my_sum(one) from (values(1),(3)) t(one);
758 select my_avg(one) filter (where one > 1),my_sum(one) from (values(1),(3)) t(one);
761 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
842 create aggregate my_sum(int4)
856 select my_sum(one),my_half_sum(one) from (values(1),(2),(3),(4)) t(one);
|
| /dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/expected/ |
| H A D | aggregates.out | 1856 create aggregate my_sum(int4)
1872 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
1875 my_avg | my_sum
1884 my_avg | my_sum
1895 my_avg | my_sum
1905 my_avg | my_sum
1911 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
1916 my_avg | my_sum
2015 create aggregate my_sum(int4)
2026 -- Agg state should be shared even though my_sum has no finalfn
[all …]
|
| /dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
| H A D | aggregates.sql | 738 create aggregate my_sum(int4)
749 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
752 select my_avg(distinct one),my_sum(distinct one) from (values(1),(3),(1)) t(one);
755 select my_avg(distinct one),my_sum(one) from (values(1),(3)) t(one);
758 select my_avg(one) filter (where one > 1),my_sum(one) from (values(1),(3)) t(one);
761 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
842 create aggregate my_sum(int4)
856 select my_sum(one),my_half_sum(one) from (values(1),(2),(3),(4)) t(one);
|
| /dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/expected/ |
| H A D | aggregates.out | 1856 create aggregate my_sum(int4)
1872 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
1875 my_avg | my_sum
1884 my_avg | my_sum
1895 my_avg | my_sum
1905 my_avg | my_sum
1911 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
1916 my_avg | my_sum
2015 create aggregate my_sum(int4)
2026 -- Agg state should be shared even though my_sum has no finalfn
[all …]
|
| /dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
| H A D | aggregates.sql | 738 create aggregate my_sum(int4)
749 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
752 select my_avg(distinct one),my_sum(distinct one) from (values(1),(3),(1)) t(one);
755 select my_avg(distinct one),my_sum(one) from (values(1),(3)) t(one);
758 select my_avg(one) filter (where one > 1),my_sum(one) from (values(1),(3)) t(one);
761 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
842 create aggregate my_sum(int4)
856 select my_sum(one),my_half_sum(one) from (values(1),(2),(3),(4)) t(one);
|
| /dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/expected/ |
| H A D | aggregates.out | 1856 create aggregate my_sum(int4)
1872 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
1875 my_avg | my_sum
1884 my_avg | my_sum
1895 my_avg | my_sum
1905 my_avg | my_sum
1911 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
1916 my_avg | my_sum
2015 create aggregate my_sum(int4)
2026 -- Agg state should be shared even though my_sum has no finalfn
[all …]
|
| /dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
| H A D | aggregates.sql | 738 create aggregate my_sum(int4)
749 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
752 select my_avg(distinct one),my_sum(distinct one) from (values(1),(3),(1)) t(one);
755 select my_avg(distinct one),my_sum(one) from (values(1),(3)) t(one);
758 select my_avg(one) filter (where one > 1),my_sum(one) from (values(1),(3)) t(one);
761 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
842 create aggregate my_sum(int4)
856 select my_sum(one),my_half_sum(one) from (values(1),(2),(3),(4)) t(one);
|
| /dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/expected/ |
| H A D | aggregates.out | 1856 create aggregate my_sum(int4)
1872 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
1875 my_avg | my_sum
1884 my_avg | my_sum
1895 my_avg | my_sum
1905 my_avg | my_sum
1911 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
1916 my_avg | my_sum
2015 create aggregate my_sum(int4)
2026 -- Agg state should be shared even though my_sum has no finalfn
[all …]
|
| /dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/ |
| H A D | aggregates.sql | 738 create aggregate my_sum(int4)
749 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
752 select my_avg(distinct one),my_sum(distinct one) from (values(1),(3),(1)) t(one);
755 select my_avg(distinct one),my_sum(one) from (values(1),(3)) t(one);
758 select my_avg(one) filter (where one > 1),my_sum(one) from (values(1),(3)) t(one);
761 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
842 create aggregate my_sum(int4)
856 select my_sum(one),my_half_sum(one) from (values(1),(2),(3),(4)) t(one);
|
| /dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/expected/ |
| H A D | aggregates.out | 1856 create aggregate my_sum(int4)
1872 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
1875 my_avg | my_sum
1884 my_avg | my_sum
1895 my_avg | my_sum
1905 my_avg | my_sum
1911 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
1916 my_avg | my_sum
2015 create aggregate my_sum(int4)
2026 -- Agg state should be shared even though my_sum has no finalfn
[all …]
|
| /dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/ |
| H A D | aggregates.sql | 738 create aggregate my_sum(int4)
749 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
752 select my_avg(distinct one),my_sum(distinct one) from (values(1),(3),(1)) t(one);
755 select my_avg(distinct one),my_sum(one) from (values(1),(3)) t(one);
758 select my_avg(one) filter (where one > 1),my_sum(one) from (values(1),(3)) t(one);
761 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
842 create aggregate my_sum(int4)
856 select my_sum(one),my_half_sum(one) from (values(1),(2),(3),(4)) t(one);
|
| /dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/expected/ |
| H A D | aggregates.out | 1877 create aggregate my_sum(int4)
1893 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
1896 my_avg | my_sum
1905 my_avg | my_sum
1916 my_avg | my_sum
1926 my_avg | my_sum
1932 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
1937 my_avg | my_sum
2046 create aggregate my_sum(int4)
2057 -- Agg state should be shared even though my_sum has no finalfn
[all …]
|
| /dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
| H A D | aggregates.sql | 752 create aggregate my_sum(int4)
763 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
766 select my_avg(distinct one),my_sum(distinct one) from (values(1),(3),(1)) t(one);
769 select my_avg(distinct one),my_sum(one) from (values(1),(3)) t(one);
772 select my_avg(one) filter (where one > 1),my_sum(one) from (values(1),(3)) t(one);
775 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
862 create aggregate my_sum(int4)
876 select my_sum(one),my_half_sum(one) from (values(1),(2),(3),(4)) t(one);
|
| /dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/expected/ |
| H A D | aggregates.out | 1877 create aggregate my_sum(int4)
1893 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
1896 my_avg | my_sum
1905 my_avg | my_sum
1916 my_avg | my_sum
1926 my_avg | my_sum
1932 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
1937 my_avg | my_sum
2046 create aggregate my_sum(int4)
2057 -- Agg state should be shared even though my_sum has no finalfn
[all …]
|
| /dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
| H A D | aggregates.sql | 752 create aggregate my_sum(int4)
763 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
766 select my_avg(distinct one),my_sum(distinct one) from (values(1),(3),(1)) t(one);
769 select my_avg(distinct one),my_sum(one) from (values(1),(3)) t(one);
772 select my_avg(one) filter (where one > 1),my_sum(one) from (values(1),(3)) t(one);
775 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
862 create aggregate my_sum(int4)
876 select my_sum(one),my_half_sum(one) from (values(1),(2),(3),(4)) t(one);
|
| /dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/expected/ |
| H A D | aggregates.out | 1877 create aggregate my_sum(int4)
1893 select my_avg(one),my_sum(one) from (values(1),(3)) t(one);
1896 my_avg | my_sum
1905 my_avg | my_sum
1916 my_avg | my_sum
1926 my_avg | my_sum
1932 select my_avg(one),my_sum(two) from (values(1,2),(3,4)) t(one,two);
1937 my_avg | my_sum
2046 create aggregate my_sum(int4)
2057 -- Agg state should be shared even though my_sum has no finalfn
[all …]
|