text.out

来自「PostgreSQL 8.1.4的源码 适用于Linux下的开源数据库系统」· OUT 代码 · 共 26 行

--
-- TEXT
--
SELECT text 'this is a text string' = text 'this is a text string' AS true;
 true 
------
 t
(1 row)

SELECT text 'this is a text string' = text 'this is a text strin' AS false;
 false 
-------
 f
(1 row)

CREATE TABLE TEXT_TBL (f1 text);
INSERT INTO TEXT_TBL VALUES ('doh!');
INSERT INTO TEXT_TBL VALUES ('hi de ho neighbor');
SELECT '' AS two, * FROM TEXT_TBL;
 two |        f1         
-----+-------------------
     | doh!
     | hi de ho neighbor
(2 rows)