-- End of contrib/pg_stat_statements/expected/select.out for REL_17_3

CREATE TABLE pgss_c AS
  SELECT id FROM generate_series(1,2) AS id;
SELECT pg_stat_statements_reset() IS NOT NULL AS t;
 t 
---
 t
(1 row)

SELECT DISTINCT id FROM pgss_c;
 id 
----
  2
  1
(2 rows)

SELECT id FROM pgss_c ORDER BY id;
 id 
----
  1
  2
(2 rows)

SELECT id FROM pgss_c LIMIT 1;
 id 
----
  1
(1 row)

SELECT id FROM pgss_c OFFSET 1;
 id 
----
  2
(1 row)

SELECT query FROM pg_stat_statements
  WHERE query LIKE '%pgss_c%'
  ORDER BY query COLLATE "C";
             query              
--------------------------------
 SELECT DISTINCT id FROM pgss_c
 SELECT id FROM pgss_c LIMIT $1
(2 rows)

SELECT pg_stat_statements_reset() IS NOT NULL AS t;
 t 
---
 t
(1 row)

SELECT id FROM pgss_c ORDER BY id;
 id 
----
  1
  2
(2 rows)

SELECT DISTINCT id FROM pgss_c;
 id 
----
  2
  1
(2 rows)

SELECT id FROM pgss_c OFFSET 1;
 id 
----
  2
(1 row)

SELECT id FROM pgss_c LIMIT 1;
 id 
----
  1
(1 row)

SELECT query FROM pg_stat_statements
  WHERE query LIKE '%pgss_c%'
  ORDER BY query COLLATE "C";
               query               
-----------------------------------
 SELECT id FROM pgss_c OFFSET $1
 SELECT id FROM pgss_c ORDER BY id
(2 rows)

SELECT pg_stat_statements_reset() IS NOT NULL AS t;
 t 
---
 t
(1 row)

DROP TABLE pgss_c;