<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>Newbie: Number appended with L?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Hola folks,</FONT>
</P>
<P><FONT SIZE=2>I'm trying to extract a subset of data from an Oracle database and import it into a PostgreSQL database. The scripts I've written work fine with MySQL, but I've encountered some problems trying to modify them to work with PG.</FONT></P>
<P><FONT SIZE=2>Currently, I dump my results into a pickle file, and use another script to upload them into the database. One row of data after extraction looks like:</FONT></P>
<P><FONT SIZE=2>['sand', 40055L, 'WALLACE', 'HUTTON', 'HUTTON,WALLACE', None, '2003-07-24', 'LAD', None, None, None, 'M', 842L, '1998-12-22', 'PAB']</FONT></P>
<P><FONT SIZE=2>Why is there an L after 40055, and another after 842? Is there something else I should be doing to cleanse those numbers?</FONT></P>
<P><FONT SIZE=2>When I import the data into MySQL, it works fine and isn't irritated by the L's. PostgreSQL, however, is rather upset about them (and the None's, which I can turn into NULL's easily enough.)</FONT></P>
<P><FONT SIZE=2>Any insight most appreciated,</FONT>
</P>
<P><FONT SIZE=2>Chris</FONT>
</P>
</BODY>
</HTML>