X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8CB7FD1B492 for ; Thu, 29 Jan 2004 16:21:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 94318-09 for ; Thu, 29 Jan 2004 12:21:08 -0400 (AST) Received: from martin.sysdetect.com (martin.sysdetect.com [65.209.102.1]) by svr1.postgresql.org (Postfix) with ESMTP id 77728D1C9C1 for ; Thu, 29 Jan 2004 12:21:06 -0400 (AST) Received: (from mail@localhost) by martin.sysdetect.com (8.11.4/8.11.3) id i0TGL1R09464 for ; Thu, 29 Jan 2004 16:21:01 GMT Received: from winwood.sysdetect.com(172.16.1.1) via SMTP by mail.sysdetect.com, id smtpdy15704; Thu Jan 29 16:20:57 2004 Received: from sysd.com (thriller.sysdetect.com [172.16.1.33]) by winwood.sysdetect.com (8.11.6/8.11.6) with ESMTP id i0TGKvb18665 for ; Thu, 29 Jan 2004 11:20:57 -0500 Message-ID: <401932E9.4010702@sysd.com> Date: Thu, 29 Jan 2004 11:20:57 -0500 From: Rich Cullingford User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030703 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: How to use int2vector Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/269 X-Sequence-Number: 12132 Hello, all. In trying to write a utility to drop/restore table indexes (as an aid to a fast reload of the associated tables), I ran into the definition of the field pg_index.indkey as an int2vector. I can't see any place in the doc that says what to do with this type, you can't cast it to any array type, and the only reference to it in the searchable archives (Thanks, pgsql.ru!) points one to contrib/intarray -- which doesn't mention int2vector at all. How can I deal with this type in plpgsql? Thanks, Rich Cullingford System Detection, Inc. rculling@sysd.com