Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 357879FB4D9 for ; Tue, 27 Mar 2007 03:47:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 85719-03 for ; Tue, 27 Mar 2007 03:47:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 9F98B9FB4C5 for ; Tue, 27 Mar 2007 03:47:16 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 7885530952; Tue, 27 Mar 2007 08:47:15 +0200 (MET DST) From: "Sabin Coanda" X-Newsgroups: pgsql.sql Subject: array_to_string Date: Tue, 27 Mar 2007 09:47:22 +0300 Organization: Hub.Org Networking Services Lines: 12 Message-ID: X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/309 X-Sequence-Number: 27947 Hi there, I used the function array_to_string, and I found it ignores NULL values, e.g. array_to_string( 'ARRAY[1,NULL,3]', ',' ) returns '1,3'. The function documentation doesn't explain this case. So please tell me: is it the normal behavior or a bug ? TIA, Sabin