I get an error when I run this one, Im new to postgresql and think
that this syntax used to work on ms sql...could be wrong, been a
while.
any suggested corrections?? thanks in advance

UPDATE ifservices
SET ifservices.notify = 'F'
WHERE id IN (
SELECT
F.id
FROM
ifservices as F,
node,
service,
categories,
category_node
WHERE
F.serviceid = service.serviceid AND
node.nodeid = F.nodeid AND
categories.categoryid = category_node.categoryid AND
category_node.nodeid = node.nodeid AND
categories.categoryname = 'Switches' AND
(service.servicename = 'SSH' OR
service.servicename = 'HTTP')

);




ERROR IS:

: ERROR: column "ifservices" of relation "ifservices" does not exist

I found the error, correction is below second SET notify = 'F'
instead of set ifservices.notify = 'F'

On Jan 7, 3:30*pm, mehoss <myfriendhe... (AT) yahoo (DOT) com> wrote: