X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 996C847646C for ; Tue, 6 May 2003 04:01:46 -0400 (EDT) Received: from 127.0.0.1 (unknown [61.94.213.183]) by postgresql.org (Postfix) with SMTP id 5EF9A47645F for ; Tue, 6 May 2003 04:01:39 -0400 (EDT) From: "Mr.F" To: Subject: Cast type int2vector/array_field to character Date: Tue, 6 May 2003 15:04:09 +0700 Message-ID: <000801c313a6$12b02b20$de00a8c0@fhf> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 1 (Highest) X-MSMail-Priority: High X-Mailer: Microsoft Outlook, Build 10.0.2616 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Importance: High In-Reply-To: <20030506012818.GA8384@wolff.to> X-GCMulti: 1 X-Spam-Status: No, hits=-1.1 required=5.0 tests=BAYES_30,IN_REP_TO,X_GCMULTI,X_MSMAIL_PRIORITY_HIGH, X_PRIORITY_HIGH version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/71 X-Sequence-Number: 13236 Forgiveness if have been asked previously. Simple question: 1. How can I cast type int2vector/array_field into character? 2. My case like this: I have 2 table, first table: Field1 Field2 ====== ====== 1 aaaaa 2 bbbbb 3 ccccc 4 ddddd 5 eeeee second table: (only one field) Array_Integer ============= 1 2 4 Wishing to be yielded from relationship both of that: Result ====== aaaaa bbbbb ddddd How command of SQL to get that result? exist in my mind now: "select * from table1 where field1 in (select Array_Integer from table2". :) Thanks in advance, Fadjar Hamidi