confused by int2vector typdelim - Mailing list pgsql-general

From jian he
Subject confused by int2vector typdelim
Date
Msg-id CACJufxFViGB-Y=fVRgb7mb8DJe4Oy09uxzVACpp18-AcM2zsSQ@mail.gmail.com
Whole thread Raw
Responses Re: confused by int2vector typdelim  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

hi.
select
        pt.typtype
        , pt.typcategory
        , pt.typdelim
        , pt.typelem  
        , pt1.typname   as elem_type
        ,pt.typsubscript
        ,pt.typname
from    pg_type pt  join pg_type pt1 on pt.typelem = pt1.oid
where   pt.typname = 'int2vector';

returns
 typtype | typcategory | typdelim | typelem | elem_type |      typsubscript       |  typname
---------+-------------+---------+----------+-----------+-------------------------+------------
 b        | A          | ,        |      21  | int2     | array_subscript_handler | int2vector
(1 row)


from manual:
typdelim char
Character that separates two values of this type when parsing array input. Note that the delimiter is associated with the array element data type, not the array data type.
 
should I expect the typdelim be a white space? Since '1 2'::int2vector works, '1,2'::int2vector does not work.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: 15 pg_upgrade with -j
Next
From: Tom Lane
Date:
Subject: Re: confused by int2vector typdelim