Hi, friend,
Suppose there is table of daily transaction data with 5 fields,
time(date), open(float8), high(float8), low(float8), close(float8)
Is it possible to create a view of weekly data, i.e. open is the first
day'open, high is the highest of the week, low is the lowest of the week, close
is the last day's close.
Thank you.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
