On Wed, Oct 12, 2005 at 08:17:23PM +0100, Oliver Elphick wrote: > On Wed, Oct 12, 2005 at 12:19:41PM -0600, Michael Fuhr wrote: > > Could you post the table definitions? > > Here it is:
I created the tables you posted (sans foreign key constraints because you didn't include the referenced tables) and loaded the data from your previous post into an 8.0.4 server on FreeBSD 4.11-STABLE. Here's what I got; it looks correct around the columns you report having trouble with: \x SELECT * FROM export_invoice; -[ RECORD 1 ]-+-------------------------------- invno | 67829 customer | 22058 account | X378 invdate | 2004-02-10 taxpoint | 2004-02-10 discount | 0.000 ordno | 5411 custref | 15498-00 currency | GBP carriage | 0.00 printed | t assigned | t customer_ean | location_ean | exchange_rate | grpid | postcode | grn | orderdate | 2004-02-10 packages | 60 packing | 0.00 other | 0.00 other_desc | 0 insurance | 0.00 pack_desc | Carton kilos | 570.000 nett | 0.000 dimensions | terms | CIF-MONTREAL/ACT 30-DAYS bank | goods | Chemist's sundries marks | AMG MEDICAL;5411;MONTREAL;1-60; port | THAMESPORT transport | SEA/ALLIANCE destination | CA origin | GB auth | MAIREAD BOYCE, DIRECTOR copies | 1 -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend