Re: cidr question (resent)

Поиск
Список
Период
Сортировка
От Alex Pilosov
Тема Re: cidr question (resent)
Дата
Msg-id Pine.BSO.4.10.10112122236180.24804-100000@spider.pilosoft.com
обсуждение исходный текст
Ответ на cidr question (resent)  ("Mir S Islam" <mislam@mindspring.com>)
Список pgsql-sql
On Wed, 12 Dec 2001, Mir S Islam wrote:

> should not the command
> DELETE from ip_space where ip = '11.0.1.0/24'::cidr
> delete last two rows ? But it does not delete anything. Basically I would
> like to be able to delete a whole range or block of ip/network addresses.

You need:
DELETE from ip_space where ip << '11.0.1.0/24'::cidr

<< is 'belongs to'. 

-alex



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Mir S Islam"
Дата:
Сообщение: cidr question (resent)
Следующее
От: David Stanaway
Дата:
Сообщение: Re: cidr question (resent)