Re: How can I do this?
От | Chris Boget |
---|---|
Тема | Re: How can I do this? |
Дата | |
Msg-id | 001d01c2b7e9$4c68e140$8c01a8c0@ENTROPY обсуждение исходный текст |
Ответ на | How can I do this? ("Boget, Chris" <chris@wild.net>) |
Список | pgsql-general |
> 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
В списке pgsql-general по дате отправления: