Postgres Pro
Downloads
Home   >   mailing lists

How to make update statement to work - Mailing list pgsql-sql

From Andrus Moor
Subject How to make update statement to work
Date
Msg-id d23u8o$228i$1@news.hub.org
Whole thread Raw
Responses Re: How to make update statement to work
List pgsql-sql
Tree view 
I want to nullify fields which does not exist in reference table.
I tried

UPDATE demo.toode       SET "liik"=NULL,            "grupp"=NULL      WHERE ("grupp",        "liik") NOT IN
(SELECT("grupp",          "liik") FROM          "artliik")
 

but this causes error:


ERROR:  operator does not exist: character = record
HINT:  No operator matches the given name and argument type(s). You may need 
to add explicit type casts.


How to write this UPDATE statement properly ?

pgsql-sql by date:

Previous
From:
Date:
Subject: Foreign key
Next
From: Kalyani Chennupati
Date:
Subject: Is there a way to find a schema name