Hi all,
I wonder why there's such difference between oracle and pg:

oracle:

(Pdb) engine.connect().execute(sql).fetchone()

select * from ruolo_permesso where cod_ruolo = 'SYSADMIN'  and 
cod_permesso='TIPO_FIGURA' and inserimento='1'

None
(1273, 'SYSADMIN', 'TIPO_FIGURA', 1, 1, 1, 1)
(Pdb) engine.connect().execute(sql).rowcount

select * from ruolo_permesso where cod_ruolo = 'SYSADMIN'  and 
cod_permesso='TIPO_FIGURA' and inserimento='1'

None
0           <--- zero??!!

===============================================================================================================

postgres:

(Pdb) engine.connect().execute(sql).fetchone()

select * from ruolo_permesso where cod_ruolo = 'SYSADMIN'  and 
cod_permesso='TIPO_FIGURA' and inserimento='1'

None
(1533, 'SYSADMIN', 'TIPO_FIGURA', True, True, True, True)
(Pdb) engine.connect().execute(sql).rowcount

select * from ruolo_permesso where cod_ruolo = 'SYSADMIN'  and 
cod_permesso='TIPO_FIGURA' and inserimento='1'

None
1

---------------------
j


--~--~---------~--~----~------------~-------~--~----~
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 
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to