aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/sql/text.sql
blob: d1c9a3e883450c704a383eca96d72e8fa7fab0d5 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
-- *************testing built-in type text  ****************

--
-- adt operators in the target list
--
-- fixed-length by reference 
SELECT 'char 16 string'::char16 = 'char 16 string '::char16 AS false;

-- fixed-length by value 
SELECT 'c'::char = 'c'::char AS true;

-- variable-length 
SELECT 'this is a text string'::text = 'this is a text string'::text AS true;

SELECT 'this is a text string'::text = 'this is a text strin'::text AS false;