Updating cidr column with network operator

Поиск
Список
Период
Сортировка
От Axel Rau
Тема Updating cidr column with network operator
Дата
Msg-id ffaabb4676ab075beb4b6d041ec280c4@Chaos1.DE
обсуждение исходный текст
Ответы Re: Updating cidr column with network operator  (Daryl Richter <daryl@brandywine.com>)
Список pgsql-sql
Hi SQLers,

I have a fk from address to network and try to update the foreign key 
column to point at the network, "it belongs to":

CREATE TABLE network (  id      cidr     PRIMARY KEY     , -- 'PK, ,IPv4/6 Network address'
)

CREATE TABLE address (  id         inet     PRIMARY KEY      , -- 'PK of IPv4/6 host address'  network cidr     NOT
NULL           -- 'FK to Network table'                      REFERENCES network ON DELETE CASCADE ON UPDATE 
 
CASCADE
)

I tried (using the WHERE clause to eliminate the addresses were no 
corresponding net exists):
UPDATE addressSET network = (SELECT N.id WHERE A.id << N.id)FROM address A, network NWHERE A.id << N.id;

But this ended up with all network columns pointing at the same net 
(-:).
Any help would be appreciated.

Axel
Axel Rau, Frankfurt, Germany                           +49-69-951418-0



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

Предыдущее
От: Hannes Dorbath
Дата:
Сообщение: Re: Copy Views From Database?
Следующее
От: Hannes Dorbath
Дата:
Сообщение: Re: Copy Views From Database?