Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 6303C633135
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat, 27 Feb 2010 13:50:50 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 97229-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat, 27 Feb 2010 17:50:39 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com
	[74.125.82.174])
	by mail.postgresql.org (Postfix) with ESMTP id B57EC633030
	for <pgsql-sql@postgresql.org>; Sat, 27 Feb 2010 13:50:39 -0400 (AST)
Received: by wya21 with SMTP id 21so613072wya.19
	for <pgsql-sql@postgresql.org>; Sat, 27 Feb 2010 09:50:38 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=UdFNnLFAAom7BX/Qf36J8RdeCoxWvHU/B4TDRBOivzI=;
	b=EELv/pGP51bt6kUfkDmYRg5Ek7fwVdPaVtRQ1Yk7Y4extJQP6d3MdjzjOfUwyO6MJe
	L2Gm0bKaxd2+b1xrvbKZla4bYcj/6DXQzfMXVT1dg3Uei+ZV62Ci/EeXiU4FDIhACPW4
	XKCBkFQwN8vmdfeML56uptGo0bjfoMu/V3Y6o=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=xK35ZdTHWBdoceJ3l6K64UPylgzxmiMBRo9KU8kUhEKfJ1zEZkh7QTzeY7nn5uNfQ6
	6Vesv1uBfMb3JN8dct0AETX8k2i4JtqvzozkWnz/S1fCTQDKUfo2xNiwBsf/qt0+mQpP
	FOF7pbQYDGmHC8nxTHx5mTRmy9hqIz1vclMTc=
MIME-Version: 1.0
Received: by 10.216.154.70 with SMTP id g48mr1485686wek.109.1267293038198;
	Sat, 27 Feb 2010 09:50:38 -0800 (PST)
In-Reply-To: 
 <74435938e3b6c5a8e9c6f9d5d8bc9f4d@intermodalsoftwaresolutions.net>
References: <4B888CAF.6030101@venaver.info>
	<74435938e3b6c5a8e9c6f9d5d8bc9f4d@intermodalsoftwaresolutions.net>
Date: Sat, 27 Feb 2010 10:50:38 -0700
Message-ID: <dcc563d11002270950l4ce7ee4bg248443ce957ee087@mail.gmail.com>
Subject: Re: Issue with insert
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Michael Gould <mgould@intermodalsoftwaresolutions.net>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201002/105
X-Sequence-Number: 33704

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
> =A0iss.citystateinfo
> (
> =A0citystateinfoid,
> =A0citystate,
> =A0zipcode,
> =A0cityname,
> =A0statecode
> )
> VALUES (
> =A0'31344342-3439-4135-2d32-3044462d3433',
> =A0'Orange Park,FL',
> =A0'32065',
> =A0'Orange Park',
> =A0'FL'
> );
>
> This inserts correctly, however when I view the data the citystate is alw=
ays
> displayed as
>
> Orange Park (FL). =A0Every row is displayed the same. =A0I've used PGAdmi=
n to
> look at the data, EMS for PostGres and have exported the data to Excel an=
d
> they all display the data incorrectly. =A0This is a issue for us because =
we
> want the user to type in either the zipcode if known to bring back the ci=
ty
> and state, or the city,state to bring back the zipcode.
>
> Any idea's on why this could be happening. =A0I'm running on Windows 7 x6=
4
> using 8.4.2

When you display it, do you use pgadmin or psql?  Does psql do the same thi=
ng?

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?