[SQL] postgres sql help

2011-10-16 Thread James Bond
hi, i am fairly new in postgresql, so if anyone can help me would be great if i simply do: select ver_no from version order by ver_no the result will be something like this: .1.3.1 .1.3.2.5. .1.4.1.7.12 .1.4.11.14.7. .1.4.3.109.1. .1.4.8.66. so as you can see first 3 lines

[SQL] Group by on Date

2011-10-16 Thread maya.more
I have a table with Date and unit column. . I want to find sum of unit column considering 3 days each User will specify start and enddate Eg DateUnit 10/1/2011 1 10/2/2011 2 10/3/2011 3 10/4/2011 4 10/5/2011 4 10/6/2011 1 10/7/2011 2 10/8/2011 3

Re: [SQL] postgres sql help

2011-10-16 Thread Andreas Kretschmer
James Bond coolof...@hotmail.com wrote: hi, i am fairly new in postgresql, so if anyone can help me would be great if i simply do: select ver_no from version order by ver_no the result will be something like this: .1.3.1 .1.3.2.5. .1.4.1.7.12 .1.4.11.14.7. .1.4.3.109.1.

Re: [SQL] postgres sql help

2011-10-16 Thread Harald Fuchs
In article snt102-w49402a41c6b6599f082d35a8...@phx.gbl, James Bond coolof...@hotmail.com writes: hi, i am fairly new in postgresql, so if anyone can help me would be great if i simply do: select ver_no from version order by ver_no the result will be something like this: .1.3.1

Re: [SQL] Group by on Date

2011-10-16 Thread Andreas Kretschmer
maya.more meena...@gmail.com wrote: I have a table with Date and unit column. . I want to find sum of unit column considering 3 days each User will specify start and enddate Eg DateUnit 10/1/2011 1 10/2/2011 2 10/3/2011 3 10/4/2011 4 10/5/2011 4

Re: [SQL] Group by on Date

2011-10-16 Thread Harald Fuchs
In article 1318661510830-4904685.p...@n5.nabble.com, maya.more meena...@gmail.com writes: I have a table with Date and unit column. . I want to find sum of unit column considering 3 days each User will specify start and enddate Eg DateUnit 10/1/2011 1 10/2/2011 2