![]() HINT: No operator matches the given name and argument type(s). update pgcast set castcontext'a' where casttarget 'boolean'::regtype Then load with pgdump. UPDATE table_name SET archived='t'::boolean WHERE id=52 UPDATE table_name SET archived='1' WHERE id=52 UPDATE table_name SET archived='t' WHERE id=52 I've tried the following: UPDATE table_name SET archived=TRUE WHERE id=52 The column in the db is currently empty so I have no others to use as a comparison. I've cut down the table description to show it's structure. No operator matches the given name and argument type(s). I'm trying to update a Postgres database to set a boolean but I'm getting the following error I've noticed that postgresql 8.1.0 can cast a boolean to text, but version > 8.1.5 CAN'T. It allows you to change the data type of an expression or a column to perform specific operations or to ensure compatibility in query results.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |