Re: User-defined typle similar to char(length) varchar(length)

> Not really, but that's another thing that seems unreasonably hard to
> fix.
>
Sorry, but more problem:

1)
postgres=# select 'as'::pg_catalog.char, 'as'::char, 'as'::char(2);
char | bpchar | bpchar
------+--------+--------
a | a | as
(1 row)

postgres=# select 'as'::pg_catalog.char(2);
ERROR: syntax error at or near "("
LINE 1: select 'as'::pg_catalog.char(2);

2)
postgres=# select char(2) 'as';
bpchar
--------
as
(1 row)

postgres=# select pg_catalog.char(2) 'as';
ERROR: syntax error at or near "'as'"
LINE 1: select pg_catalog.char(2) 'as';

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/