In PostgreSQL, this code:
{{{
# select a row from website_type_tbl(wtype_id INTEGER PK, show_ads
BOOLEAN)
row = website_type_tbl.select().execute().fetchone()
# insert another row
website_type_tbl.insert().execute(wtype_id=5, show_ads=row.show_ads)
}}}
Produces error - SQLError: (ProgrammingError) ERROR: column "show_ads"
is of type boolean but expression is of type integer
What happens is, while fetching, boolean columns are fetched as integer
type (0, 1).
I don't know whether it is the expected behaviour or a bug. Bringing
to notice, in case it is a bug.
thanks
sanjay
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
