confused by int2vector typdelim
| От | jian he |
|---|---|
| Тема | confused by int2vector typdelim |
| Дата | |
| Msg-id | CACJufxFViGB-Y=fVRgb7mb8DJe4Oy09uxzVACpp18-AcM2zsSQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: confused by int2vector typdelim
|
| Список | 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)
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:
typdelimcharCharacter 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 по дате отправления: