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
wouldthe SQL code look like if I have these two statements (one returning an array, the other taking this array and
comparesit 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
