Re: array issue....

On Thu, 19 Sep 2002, Len Morgan wrote:

Woops,

I forgot to paste the actual query... :(..

delete from account_info where contact_id = 242;

is the query, and I'm not even using the column that is of type array[]....

> Why do you need to reference an array (i.e., column) when what you are
> trying to do is remove a row? Is it because the array contains some special
> value (like NULL) and that is the criteria for deleting? If not, just
> DELETE FROM <tablename> WHERE <where clause>;
>
> Len Morgan
>
> ----- Original Message -----
> From: "Chris Bowlby" <excalibur(at)hub(dot)org>
> To: <pgsql-general(at)postgresql(dot)org>
> Sent: Thursday, September 19, 2002 7:37 AM
> Subject: [GENERAL] 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
> > -----------------------------------------------------
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
> >
>
>
>

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