X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 595EA53C91 for ; Sun, 6 Mar 2005 19:11:07 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35548-07 for ; Sun, 6 Mar 2005 19:11:01 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id DFBE152A7D for ; Sun, 6 Mar 2005 19:10:59 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j26JAtgM008524 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Sun, 6 Mar 2005 12:10:58 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j26JAtjX008869; Sun, 6 Mar 2005 12:10:55 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j26JAtKC008868; Sun, 6 Mar 2005 12:10:55 -0700 (MST) (envelope-from mfuhr) Date: Sun, 6 Mar 2005 12:10:55 -0700 From: Michael Fuhr To: bandeng Cc: pgsql-sql@postgresql.org Subject: Re: count array in postgresql Message-ID: <20050306191055.GA8834@winnie.fuhr.org> References: <3817e22905030608544a2aac9a@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3817e22905030608544a2aac9a@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/85 X-Sequence-Number: 20564 On Sun, Mar 06, 2005 at 11:54:15PM +0700, bandeng wrote: > I need some help, I have created function with argument in array. > I already try to find array function in manual but failed. Maybe you're looking for "Array Functions and Operators" in the "Functions and Operators" chapter. You don't say what version of PostgreSQL you're using; here's a link to the 8.0 documentation: http://www.postgresql.org/docs/8.0/interactive/functions-array.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/