Thread: how to array and other select

Hello the list

Before all : happy new year for all.

I Don't know how can I write a sql select.

I have 2 tables :
One with an array of codes

and another with a code

I try to retrieve the array of codes from the first table and return
only the codes existing on the second table
If possible I search also to retrieve 2 others fields from the first
table that corresponds to the code array value



I have :
  SELECT tcode[idx] AS code FROM (SELECT tcode,
generate_series(array_lower(tcode,1), array_upper(tcode,1)) AS idx FROM
table_cat_origin WHERE code=120 ) asdf
  UNION
  SELECT code FROM table_f260_cat_origin
;

but the number of returned rows are incorrect.

Anyone can help me ?

Thanks in advance

Guy