the array contains the values of INT4 fields from a database. I need that INT4 field value. I know that ARRAY(XXXXXXX) is a reference. I don't care about the memory location. I want what's in the memory location.

I want a SQL statement that reads "select * from rockstars where name = 'ringo' "

What I am getting is a SQL statement that reads "select * from rockstars where name = ARRAY(XXXXXXX) "

Ok... is there more than one entry in the array, or just one. if there are more than one entry in the array which one(s) do you want?
                - Ant

There is more than one value in the array. In my example $self->tsids contains a list or an array. Its just a bunch of values returned from the database.

I wanted to use foreach $var($self->tsids) to iterate over the list and create a new object for each item in the list.