blob: b53557bf2af725eb0721f9e4a77eeb2529acab95 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
CREATE EXTENSION chkpass;
WARNING: type input function chkpass_in should not be volatile
CREATE TABLE test (i int, p chkpass);
INSERT INTO test VALUES (1, 'hello'), (2, 'goodbye');
SELECT i, p = 'hello' AS "hello?" FROM test;
i | hello?
---+--------
1 | t
2 | f
(2 rows)
SELECT i, p <> 'hello' AS "!hello?" FROM test;
i | !hello?
---+---------
1 | f
2 | t
(2 rows)
|
