Re: [GENERAL] last and/or first in a by group

2010-05-21 Thread Dino Vliet
From: "Thomas Kellerer" To: "" Dino Vliet wrote on 16.05.2010 18:07: > Dear postgresql experts, > > I want to know if postgresql has facilities for getting the first and or > the last in a by group. > > Suppose I have the following table: > > resnr,dep,arr,cls,dbd meaning reservationsnumber, d

Re: [GENERAL] last and/or first in a by group

2010-05-16 Thread Tim Landscheidt
Dino Vliet wrote: > I want to know if postgresql has facilities for getting the first and or the > last in a by group. > Suppose I have the following table: > resnr,dep,arr,cls,dbd meaning reservationsnumber, departure station, arrival > station, the class of the reservation and the daysbefor

Re: [GENERAL] last and/or first in a by group

2010-05-16 Thread Thomas Kellerer
Dino Vliet wrote on 16.05.2010 18:07: Dear postgresql experts, I want to know if postgresql has facilities for getting the first and or the last in a by group. Suppose I have the following table: resnr,dep,arr,cls,dbd meaning reservationsnumber, departure station, arrival station, the class of