Re: CREATE TYPE delimiter? - Mailing list pgsql-general

From Tom Lane
Subject Re: CREATE TYPE delimiter?
Date
Msg-id 2664.1004813475@sss.pgh.pa.us
Whole thread Raw
In response to CREATE TYPE delimiter?  ("Command Prompt, Inc." <pgsql-general@commandprompt.com>)
Responses Re: CREATE TYPE delimiter?  ("Command Prompt, Inc." <pgsql-general@commandprompt.com>)
List pgsql-general
"Command Prompt, Inc." <pgsql-general@commandprompt.com> writes:
> Just wondering if anyone knows the reason for the DELIMITER keyword in
> CREATE TYPE? The documentation states that it sets the value delimiter if
> you are creating an array data type, but setting this value to something
> other than a comma neither seems to affect the input nor output
> representation--that is, a comma still appears to be required on input,
> and displayed on output, regardless of what I set the DELIMITER to.

?? What was your test case exactly?  A casual perusal of arrayfuncs.c
certainly looks like array_in and array_out use the specified delimiter
character, not a hardwired comma.

            regards, tom lane

pgsql-general by date:

Previous
From: "Command Prompt, Inc."
Date:
Subject: Re: Sum(time) possible?
Next
From: Gunnar Lindholm
Date:
Subject: Re: how do the pro's do this? (still a newbie)