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 ar
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
10/
James Bond 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.
> .1.4.8.66.
>
In article ,
James Bond 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
> .1.3.2.5.
> .1.4.1.7.12
> .1.4.11.14.7.
> .1.4.3.109.1.
> .1.4.8.
maya.more 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
> 10/6/
In article <1318661510830-4904685.p...@n5.nabble.com>,
"maya.more" 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
> 10/3/201
