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 -~----------~----~----~----~------~----~------~--~---