You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
File "asyncpg\protocol\protocol.pyx", line 181, in bind_execute
File "asyncpg\protocol\prepared_stmt.pyx", line 171, in asyncpg.protocol.protocol.PreparedStatementState._encode_bind_msg
asyncpg.exceptions.DataError: invalid input for query argument $3: False (expected str, got bool)
I tried to use it with sqlalchemy and it is correctly returning True/False values.
Is it some issue with postgres driver or database library?
I tried to replace True/False with 'True'/'False' and it is working.
Is there another way to return boolean values?
This discussion was converted from issue #302 on March 24, 2021 09:45.
Heading
Bold
Italic
Quote
Code
Link
Numbered list
Unordered list
Task list
Attach files
Mention
Reference
Menu
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hi,
I can not use True or False in case function as below
it is showing me this error
I tried to use it with sqlalchemy and it is correctly returning True/False values.
Is it some issue with postgres driver or database library?
I tried to replace True/False with 'True'/'False' and it is working.
Is there another way to return boolean values?
Kind regards
Beta Was this translation helpful? Give feedback.
All reactions