X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4A756DA08E for ; Wed, 21 Sep 2005 22:56:36 -0300 (ADT) 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 67159-10 for ; Thu, 22 Sep 2005 01:56:31 +0000 (GMT) Received: from web35205.mail.mud.yahoo.com (web35205.mail.mud.yahoo.com [66.163.179.84]) by svr1.postgresql.org (Postfix) with SMTP id 3A7D6DA09E for ; Wed, 21 Sep 2005 22:56:32 -0300 (ADT) Received: (qmail 72035 invoked by uid 60001); 22 Sep 2005 01:56:36 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=JjoNnf4OQxps1jS2iYkMPs9+MPNwh01BcYK7+cCYslRcYZA0NrAW9X+t4ZBC2hjxBjtTW7LX5jUKxTCfbP2WmtSD3+YoDyzaSZEpf60o8256z7pf4mDeqIzS/FKmOPyCLV71Cn6sXNu3eTKvN1bbP+DLAKuJBAdWOP9MUS1Woxo= ; Message-ID: <20050922015636.72033.qmail@web35205.mail.mud.yahoo.com> Received: from [70.104.144.58] by web35205.mail.mud.yahoo.com via HTTP; Wed, 21 Sep 2005 18:56:36 PDT Date: Wed, 21 Sep 2005 18:56:36 -0700 (PDT) From: Matthew Peter Subject: delete item[5] from varchar[] array??? To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.255 required=5 tests=[AWL=-0.119, DNS_FROM_RFC_ABUSE=0.374] X-Spam-Level: X-Archive-Number: 200509/192 X-Sequence-Number: 22739 How is it possible to delete an item from a single dimension varchar[] array? Lets say it has the values {1,2,3,4,5,6}... how do i delete at position [4]? Could this be done in a SQL statement or a function? I appreciate any help. Thank you MP ______________________________________________________ Yahoo! for Good Donate to the Hurricane Katrina relief effort. http://store.yahoo.com/redcross-donate3/