From: | Ruzsinszky Attila <ruzsinszky(dot)attila(at)gmail(dot)com> |
---|---|
To: | "Oliveiros C," <oliveiros(dot)cristina(at)marktest(dot)pt> |
Cc: | postgresql novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Modifying selected records |
Date: | 2009-09-02 17:14:43 |
Message-ID: | f637dd860909021014s57aa6601o4b352f5fafda75be@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
> I think I need at least an order by count or indul_ido. Where do I have to
> put it?
I found the answer: at the end of the statement. ;-)
> Other problem is these two records:
> 23;"5501289";"Győr";1;"07:41:00";"07:41:00";"910_23"
> 28;"5544800";"Csorna";1;"08:00:00";"08:00:00";"910_28"
>
> It is correct we eliminated the double record but it is not enough!
After order by count I found my previous sentence wasn't true!
So we have to focus to this problem:
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"
28;"5544800";"Csorna";1;"08:00:00";"08:00:00";"910_28"
29;"5544800";"Csorna";1;"08:12:00";"08:12:00";"910_29"
Now I revised the result records. I don't want to change the
train_selector except the duplicated records. I think you
misunderstood my task. Train_selector has to be modified
because the duplicated record will be merged in only one
record and the original train_selector related to the original
records.
TIA,
Ruzsi
From | Date | Subject | |
---|---|---|---|
Next Message | Ruzsinszky Attila | 2009-09-02 18:18:07 | Re: Modifying selected records |
Previous Message | Ruzsinszky Attila | 2009-09-02 16:55:23 | Re: Modifying selected records |