array_to_string bug? - Mailing list pgsql-hackers

From David Fetter
Subject array_to_string bug?
Date
Msg-id 20091112155513.GB26790@fetter.org
Whole thread Raw
Responses Re: array_to_string bug?
List pgsql-hackers
Folks,

Here's expected behavior:

davidfetter@postgres=# SELECT array(values(1),(null));?column? 
──────────{1,NULL}
(1 row)

The next one is just plain unexpected.  Either it's a bug, or it needs
more documentation in the function description in the docs, \df+
output, etc.

davidfetter@postgres=# SELECT array_to_string(array(values(1),(null)),'');array_to_string 
─────────────────1
(1 row)

I would have expected it to come out as NULL.

What say?

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Listen / Notify rewrite
Next
From: Joachim Wieland
Date:
Subject: Re: Listen / Notify rewrite