Re: [Pypgsql-users] Trouble supporting mixed case entities.

[Gerhard <gh...@gh...>]

* Benjamin Scherrey <sch...@pr...> [2003-03-31 18:45 -0500]:
> [...]
>         cstmt = r"""create table "Test" ( "FName" varchar(20), "LName" varchar(20) )"""
>         istmt = r"""insert into "Test" values ( 'Benjamin', 'Scherrey' )"""
>         sstmt = r"""select "FName", "LName" from "Test" """
> [...]
>     
>     print res["fname"]
>     print res["lname"]

If you use quotes around SQL identifiers, case matters. Try:

print res["FName"], res["LName"]

or even:

print res.FName, res.LName

Gerhard
-- 
mail:   gh...@gh...
web:    http://ghaering.de/