Date: Fri, 8 Apr 2005 12:51:47 -0400
From: Stef <stef@ummon.com>
To: pgsql-sql@postgresql.org
Subject: Numeric and CSV under 8.0.1 ?
Message-ID: <20050408165147.GV30669@survivor.hades>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="r+TdwuXy+OXS8TUs"
Content-Disposition: inline
User-Agent: Mutt/1.5.6i


--r+TdwuXy+OXS8TUs
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hello Everyone,
	Currently, here at work, I am doing the whole
'advocacy' part of postgreSQL. It's not really hard to
do, as the other database's are MySQL and Sybase ;)

	There is obviously a whole spat of data munging
going on in the background, and I noticed that psql in
8.0.1 now accepts CSV ! Great.=20

	Except, it doesn't really appear to be 100% there.
Numeric's wrapped in '...' don't want to appear to go in.
Is this a 'known problem' ?

                    Table "public.visitor_main"
      Column      |         Type         |          Modifiers          =20
------------------+----------------------+------------------------------
 iuserid          | numeric(12,0)        | not null
 firstname        | character(25)        | not null
 lastname         | character(25)        | not null


Sample Data line
'3236','Alonzo','Peter'

ERROR:  invalid input syntax for type numeric: "'3236'"
CONTEXT:  COPY visitor_main, line 1, column iuserid: "'3236'"


	Thoughts ?
	Regards
	Steph

--r+TdwuXy+OXS8TUs
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQFCVrajjI9jiT2RxJQRAgSAAJ91MnHhVDa8WDHKrx04xkJ8aEXbmwCdH2Ou
kqW5Yj/GEDBxamgmCHbuf1I=
=tdc3
-----END PGP SIGNATURE-----

--r+TdwuXy+OXS8TUs--