array issue....

Hi All,

I know it was bad design on my part but I've got a table that has one
field that is an array (it's not even used), and I need to delete a row
from the table. Each time I try and remove it I get this error:

ERROR: Unable to identify an operator '=' for types 'integer[]' and 'integer'
You will have to retype this query using an explicit cast

I can not find any documentation on how to cast an array so it can be
properly deleted and the archives are also returning pretty much nothing..

could someone point me in the right direction please? :>

Chris Bowlby,
-----------------------------------------------------
Manager of Information and Technology.
excalibur(at)hub(dot)org
www.hub.org
1-902-542-3657
-----------------------------------------------------