Searching in Arrays

[Ferruh Zamangoer]

Hi,

 

we want to use Torque with a PostgresSQL Database does Torque support
searching in arrays? On the postgresSQL website I see that postgres supports
it. The search query is below:

 

SELECT * FROM sal_emp WHERE pay_by_quarter[1] = 10000 AND

                            pay_by_quarter[2] = 1000 AND

                            pay_by_quarter[3] = 1000 AND

                            pay_by_quarter[4] = 1000;

 

Thanks for any help in advance.

Regards

Ferruh