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

From Teodor Sigaev
Subject Re: User-defined typle similar to char(length) varchar(length)
Date
Msg-id 44CF6983.5060605@sigaev.ru
Whole thread Raw
In response to Re: User-defined typle similar to char(length) varchar(length)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: User-defined typle similar to char(length) varchar(length)
List pgsql-hackers
> 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@sigaev.ru
  WWW: http://www.sigaev.ru/
 


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Hash indexes (was: On-disk bitmap index patch)
Next
From: Martijn van Oosterhout
Date:
Subject: Re: User-defined typle similar to char(length) varchar(length)