Re: User-defined typle similar to char(length) varchar(length) - Mailing list pgsql-hackers

>     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: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/