How to null fields in PostgreSQL?

A

AlmazKayum2019-05-05 18:36:33

PostgreSQL

AlmazKayum, 2019-05-05 18:36:33

Good afternoon.
I am trying to reset the table fields using the command

UPDATE filters SET height_low=NULL|height_high=NULL WHERE chat_id=%s

gives an error message

psycopg2.ProgrammingError: column "height_low" is of type integer but expression is of type boolean
HINT:  You will need to rewrite or cast the expression.

It is necessary to convert integer to NULL, what can be done?

Reply

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

E

EVOSandru62017-09-04 15:30:29

What is the best entity to pack the intermediate in the offer->intermediate_link->coupon? 0Reply

I

Ivan Palamarchuk2017-09-04 17:28:45

Pseudo-persistent connection in PHP, is it possible? 2Reply

B

BonBon Slick2017-09-07 12:42:26

Laravel Homestead DB port 5432 is running - site, but artisan is broken, 54320 is running artisan - site is broken? 0Reply

G

GrimJack2017-09-08 17:33:26

What is the best way to search by json cell? 1Reply

C

Caefah2017-09-14 10:28:49

How to properly organize geographically distributed asynchronous replication between PostgreSQL-XL clusters? 1Reply

Didn't find what you were looking for?

Ask your question