On Sat, Feb 27, 2010 at 10:14 AM, Michael Gould <mgo...@intermodalsoftwaresolutions.net> wrote: > I'm having a issue with a insert > > INSERT INTO > iss.citystateinfo > ( > citystateinfoid, > citystate, > zipcode, > cityname, > statecode > ) > VALUES ( > '31344342-3439-4135-2d32-3044462d3433', > 'Orange Park,FL', > '32065', > 'Orange Park', > 'FL' > ); > > This inserts correctly, however when I view the data the citystate is always > displayed as > > Orange Park (FL). Every row is displayed the same. I've used PGAdmin to > look at the data, EMS for PostGres and have exported the data to Excel and > they all display the data incorrectly. This is a issue for us because we > want the user to type in either the zipcode if known to bring back the city > and state, or the city,state to bring back the zipcode. > > Any idea's on why this could be happening. I'm running on Windows 7 x64 > using 8.4.2
When you display it, do you use pgadmin or psql? Does psql do the same thing? Can we see the ddl that created this table? Can you create a self-contained test-case that others can run and see the same results? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql