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 1DB7FDA1AB for ; Thu, 22 Sep 2005 01:13:15 -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 16561-08 for ; Thu, 22 Sep 2005 04:13:11 +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 7117ED8365 for ; Thu, 22 Sep 2005 01:13:08 -0300 (ADT) Received: (qmail 98280 invoked by uid 60001); 22 Sep 2005 04:13:07 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=6JC9b1g74lku9z9eLHTeWtYhlailxG4SSFNoAZGRg7msA8oBtSgEGYfugb/nN9n9OY9cTvZ8lCGlZmzhFYtiJUkzb8twFuEr7377Br7PHAoToQIQ3V3/AFY6pdnjkNC/lUWlqWMq4MHq4VnembLOmZ6i6repGSwKmBdUz97Mbnw= ; Message-ID: <20050922041307.98278.qmail@web35205.mail.mud.yahoo.com> Received: from [70.104.144.58] by web35205.mail.mud.yahoo.com via HTTP; Wed, 21 Sep 2005 21:13:07 PDT Date: Wed, 21 Sep 2005 21:13:07 -0700 (PDT) From: Matthew Peter Subject: Re: delete item[5] from varchar[] array??? To: Tom Lane Cc: pgsql-sql@postgresql.org In-Reply-To: <24056.1127359028@sss.pgh.pa.us> 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.263 required=5 tests=[AWL=-0.111, DNS_FROM_RFC_ABUSE=0.374] X-Spam-Level: X-Archive-Number: 200509/195 X-Sequence-Number: 22742 Ya. I didn't see any in the \df. If it's so simple could you show me one? PLEEEEEEEEEEEASE Thanks MP --- Tom Lane wrote: > Matthew Peter writes: > > How is it possible to delete an item from a single > > dimension varchar[] array? > > AFAIR there is no built-in function for this, but it > seems like you > could write a generic polymorphic function for it > easily enough. > > regards, tom lane > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com