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