Postgresql – Why psycopg cursor.fecthone return a list of None if no row was hit from select query?
My function to query account by email: CREATE FUNCTION get_account_by_email(account_email varchar(64)) RETURNS account AS $$ SELECT id, name, email FROM account WHERE account.email = account_email; $$ LANGUAGE SQL; My python code to call the function ("psycopg[binary]"==3.1.9): async def get_account_by_email(self, email:…