array issue.... - Mailing list pgsql-general

From Chris Bowlby
Subject array issue....
Date
Msg-id 20020919093521.L243-100000@wired.hub.org
Whole thread Raw
List pgsql-general
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@hub.org
 www.hub.org
 1-902-542-3657
 -----------------------------------------------------


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: IN vs EXIIST
Next
From: Martijn van Oosterhout
Date:
Subject: Re: NUMERIC and arithmetics