On Fri, 19 Jan 2001, Florent Guillaume wrote:
> I just discoverred arrays, and I'm wondering if there's a way to do,
> given table t1 (v int4, a int4[]), a query that does in effect :
> "select v, i from t1 where EXISTS i SUCHTHAT a[i] = 45;"
>
> I know I can do it with a separate table and a j
I just discoverred arrays, and I'm wondering if there's a way to do,
given table t1 (v int4, a int4[]), a query that does in effect :
"select v, i from t1 where EXISTS i SUCHTHAT a[i] = 45;"
I know I can do it with a separate table and a join, but this would
be much nicer.
Also, I wanted to me
I just discoverred arrays, and I'm wondering if there's a way to do,
given table t1 (v int4, a int4[]), a query that does in effect :
"select v, i from t1 where EXISTS i SUCHTHAT a[i] = 45;"
I know I can do it with a separate table and a join, but this would
be much nicer.
Also, I wanted to me
