github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/logic_test/function_lookup (about)

     1  statement ok
     2  CREATE TABLE foo(x INT DEFAULT length(pg_typeof(1234))-1)
     3  
     4  statement ok
     5  CREATE TABLE bar(x INT, CHECK(pg_typeof(123) = 'bigint'))
     6  
     7  statement ok
     8  ALTER TABLE foo ALTER COLUMN x SET DEFAULT length(pg_typeof(123))
     9  
    10  statement ok
    11  ALTER TABLE foo ADD CONSTRAINT z CHECK(pg_typeof(123) = 'bigint')
    12  
    13  query T
    14  SELECT pg_typeof(123)
    15  ----
    16  bigint
    17  
    18  query I
    19  SELECT count(*) FROM foo GROUP BY pg_typeof(x)
    20  ----
    21  
    22  query I
    23  SELECT * FROM foo LIMIT length(pg_typeof(123))
    24  ----
    25  
    26  query I
    27  SELECT * FROM foo WHERE pg_typeof(x) = 'bigint'
    28  ----
    29  
    30  query T
    31  INSERT INTO foo(x) VALUES (42) RETURNING pg_typeof(x)
    32  ----
    33  bigint
    34  
    35  # CockroachDB is case-preserving for quoted identifiers like pg, and
    36  # function names only exist in lowercase.
    37  query error unknown function: PG_TYPEOF\(\), but pg_typeof\(\) exists
    38  SELECT "PG_TYPEOF"(123)