Re: Cast type int2vector/array_field to character

On Tue, 6 May 2003, Mr.F wrote:

> 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". :)

look at contrib/intarray package.

> 
> Thanks in advance,
> Fadjar Hamidi
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 

-- 
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-210-8981112
fax:    +30-210-8981877
email:  achill@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr