Re: confused by int2vector typdelim

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: confused by int2vector typdelim
Date: 2023-05-24 14:09:58
Message-ID: 1125496.1684937398@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

jian he <jian(dot)universality(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2023-05-24 17:34:17 Re: 15 pg_upgrade with -j
Previous Message jian he 2023-05-24 07:56:51 confused by int2vector typdelim