Re: How to hand over array as variable in plpgsql function?

Hi Tom (and hello all again),
thanks for your reply.

> Seems like using EXECUTE is the hardest possible way to do this. Why
> don't you just SELECT?
>
> SELECT id FROM precip_arrays WHERE b = precip_control INTO id_result;

How should the code look like to do this? I am using EXECUTE because I don't know how to write the SQL equivalent. How would the SQL code look like if I have these two statements (one returning an array, the other taking this array and compares it to some other arrays in the db):

SELECT precip_control FROM precip_arrays WHERE id = 400; --returns an array
SELECT id FROM precip_arrays WHERE [THE RETURNED ARRAY] = precip_scenario;--compares the above array to the arrays in colum "precip_scenario".

This obviously does NOT work:

SELECT id FROM precip_arrays WHERE (SELECT precip_control FROM precip_arrays WHERE id = 400;) = precip_control;

Is something like the above statement possible?

Sorry for my ignorance and thanks in advance again

Jan

--

Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer