Re: confused by int2vector typdelim - Mailing list pgsql-general

From Tom Lane
Subject Re: confused by int2vector typdelim
Date
Msg-id 1125496.1684937398@sss.pgh.pa.us
Whole thread Raw
In response to confused by int2vector typdelim  (jian he <jian.universality@gmail.com>)
List pgsql-general
jian he <jian.universality@gmail.com> writes:
> should I expect the typdelim be a white space? Since '1 2'::int2vector
> works, '1,2'::int2vector does not work.

typdelim applies to the type's associated array type, that is
int2vector[].

regression=# select '{1 2,3 4 5}'::int2vector[];
   int2vector    
-----------------
 {"1 2","3 4 5"}
(1 row)

            regards, tom lane



pgsql-general by date:

Previous
From: jian he
Date:
Subject: confused by int2vector typdelim
Next
From: Alvaro Herrera
Date:
Subject: Re: 15 pg_upgrade with -j