1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
# name: test/sql/pg_catalog/pg_settings.test
# description: Test pg_settings function
# group: [pg_catalog]
statement ok
SET default_null_order='nulls_first';
statement ok
SELECT * FROM pg_settings;
query II
SELECT name, setting FROM pg_settings WHERE name='default_null_order';
----
default_null_order NULLS_FIRST
statement ok
SET default_null_order='nulls_last'
query II
SELECT name, setting FROM pg_settings WHERE name='default_null_order';
----
default_null_order NULLS_LAST
|
