You are viewing a plain text version of this content. The canonical link for it is here.

Posted to torque-user@db.apache.org by Ferruh Zamangoer <fe...@gmx.de> on 2005/06/08 17:10:30 UTC

Searching in Arrays

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