Skip site navigation (1) Skip section navigation (2)

Re: Modifying selected records

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 (view raw or flat)
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

In response to

Responses

pgsql-novice by date

Next:From: Ruzsinszky AttilaDate: 2009-09-02 18:18:07
Subject: Re: Modifying selected records
Previous:From: Ruzsinszky AttilaDate: 2009-09-02 16:55:23
Subject: Re: Modifying selected records

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group