Cast type int2vector/array_field to character

From: "Mr(dot)F" <fhf_it(at)csahome(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Cast type int2vector/array_field to character
Date: 2003-05-06 08:04:09
Message-ID: 000801c313a6$12b02b20$de00a8c0@fhf
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Marco Roda 2003-05-06 09:05:46 Re: UNICODE and SQL
Previous Message Rajesh Kumar Mallah 2003-05-06 06:37:54 Re: mnogosearch examples