pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Michael Gould <mgould@intermodalsoftwaresolutions.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Issue with insert
Date: Sat, 27 Feb 2010 10:50:38 -0700
Message-ID: <dcc563d11002270950l4ce7ee4bg248443ce957ee087@mail.gmail.com> (raw)
In-Reply-To: <74435938e3b6c5a8e9c6f9d5d8bc9f4d@intermodalsoftwaresolutions.net>
References: <4B888CAF.6030101@venaver.info>
	<74435938e3b6c5a8e9c6f9d5d8bc9f4d@intermodalsoftwaresolutions.net>

On Sat, Feb 27, 2010 at 10:14 AM, Michael Gould
<mgould@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?



view thread (5+ messages)  latest in thread

Message-ID: <dcc563d11002270950l4ce7ee4bg248443ce957ee087@mail.gmail.com>
Permalink:  ../dcc563d11002270950l4ce7ee4bg248443ce957ee087@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d11002270950l4ce7ee4bg248443ce957ee087@mail.gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: scott.marlowe@gmail.com, mgould@intermodalsoftwaresolutions.net
  Subject: Re: Issue with insert
  In-Reply-To: <dcc563d11002270950l4ce7ee4bg248443ce957ee087@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox