Re: Modifying selected records
| От | Ruzsinszky Attila |
|---|---|
| Тема | Re: Modifying selected records |
| Дата | |
| Msg-id | f637dd860909030444v581f0597gdb61328526954e36@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Modifying selected records ("Oliveiros C," <oliveiros.cristina@marktest.pt>) |
| Список | pgsql-novice |
Hi, > 22;"5501289";"Győr";1;"07:39:00";"07:39:00";"910_22" > 23;"5501289";"Győr";1;"07:41:00";"07:41:00";"910_23" I'd like this: <next count>; "5501289";"Győr"; "07:39:00"; "07:41:00"; "910_unknown" > 28;"5544800";"Csorna";1;"08:00:00";"08:00:00";"910_28" > 29;"5544800";"Csorna";1;"08:12:00";"08:12:00";"910_29" For Csorna: <next count>;"5544800";"Csorna";1;"08:00:00";"08:12:00";"910_unknown2" _unknown means: it is a programmed selector, so not valid. As you can see I want to merge the two time date in one record. The problem comes from some specification misunderstood. This timetable comes from three (almos) independent XML files. > Indeed, I am not sure if I am understanding what you need. Ihope you understand now. > By duplicated record you mean records that have the first three columns the > same ? E.G. ;"5544800";"Csorna";1; ? Csorna and Győr is the problematic. > And in these cases what do you need the train selector to be exactly? I don't know exactly. I'm sure I have to change it because in the merged record the sector is not valid. > The left part of it (910) means what exactly? vonatszam. In English: train number. TIA, Ruzsi
В списке pgsql-novice по дате отправления: