> So if you have
> card_id | card_name
> --------+--------------
> 277 | 123456789abc
> 727 | 123456789bbc
> 772 | 123456789bca
> which card_id do you want to select for trader_haves_old.card_name =
> '123456789bbc'?
That's a perfectly valid point. And as I said, I'd be able to get the proper
record number for 99+%. Happily, there aren't situations like the one you
describe. The names of the cards are almost all distinguishable within the
first 9 characters. That's why I chose it as my aribitrary value. :p
> >Sadly, the MySQL database wasn't normalized and I've been running into a
> >lot of roadblocks (mainly from the fact that I'm still learning PG) in converting
> >it over.
> While you are still unfamiliar with the new DB, don't make several steps at once.
> Strictly separate the tasks of
> a) importing data,
Already done in temporary holding tables.
> b) cleaning up structures (normalization),
Done. These are the tables I'm trying to move the data to.
> c) cleaning up data.
Haven't done this. Perhaps it would be a good idea to update the temp table with
the proper values before moving over the the actual table. This would certainly
make things a heck of a lot easier!
> Good luck!
Thank you very much for your help and your advice!
Chris