Arrays advanced usage

From: Florent Guillaume <florent(dot)guillaume(at)mail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Arrays advanced usage
Date: 2001-01-19 14:46:44
Message-ID: 20010119154644.A4566@twin.efge.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 mention that no "reference" is pointed directly from
http://www.postgresql.org/devel-corner/docs/index.html
(you have to go through "postgres" to find it, I think it's not very
intuitive).

Florent

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-01-19 15:10:33 Re: initdb doesn not create template1 database
Previous Message Trurl McByte 2001-01-19 14:27:56 temporary table check?