array issue....

Поиск
Список
Период
Сортировка
От Chris Bowlby
Тема array issue....
Дата
Msg-id 20020919093521.L243-100000@wired.hub.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: IN vs EXIIST
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: NUMERIC and arithmetics