2010/5/4 Josh Berkus <j...@agliodbs.com>: > >> quietly removing NULL is maybe good for compatibility but is wrong for >> functionality. > > I agree. I wasn't aware of this little misfeature. > > Default display for NULL should be a zero-length string. >
I disagree - NULL is NULL, not empty string (Oracle is different) if array_to_string is equivalent to x[1] || sep || x[2] || sep || x[3] || sep .... then correct result is NULL and then string_to_array and array_to_string are correct, because string_to_array cannot contain any NULL symbol. Regards Pavel Stehule > -- > -- Josh Berkus > PostgreSQL Experts Inc. > http://www.pgexperts.com > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
