char(42) 'literal value here'



Playing around that I noticed:

postgres=# select '{asd}'::text[], '{asd}'::_text, _text '{asd}';
 text  | _text | _text
-------+-------+-------
 {asd} | {asd} | {asd}
(1 row)

postgres=# select text[] '{asd}';
ERROR:  syntax error at or near "]"
LINE 1: select text[] '{asd}';

Is it desired effect?


--
Teodor Sigaev                                   E-mail: [EMAIL PROTECTED]
                                                   WWW: http://www.sigaev.ru/

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to