On 11/18/2011 10:46 AM, Paul McNett wrote: d > > Since postgres turns "abc" into "abc " when updating, and since postgres > strips > the padded spaces in comparisons, it seems to follow that when psycopg2 > fetches the > data from postgres, it should strip out the trailing spaces in char fields so > that > python comparisons of the data don't take into account the padded spaces.
Since word padding handling tends to vary so much I tend to be explicit as possible when doing field comparisons. Examples: On database side: SELECT trim(some_field), ... OR On Python side: some_field_value.strip() > > Paul > > -- Adrian Klaver [email protected] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
