By the way, if you want to include that "incomplete" week before 12/1
(incomplete because it doesn't have a data point for Monday) then you would
do this:
select s1.asx_code, s1.wdate AS date, s1.low, s1.high, s2.open, s3.close,
s1.volume
from (select asx_code, date_trunc('week', date) AS wdate,
John,
Sub-selects to the rescue. See below.
select s1.asx_code, s1.bdate AS date, s1.low, s1.high, s2.open, s3.close,
s1.volume
from (select asx_code, date_trunc('week', date) AS bdate, max(date) AS
edate, min(low) AS low, max(high) AS high, sum(volume) AS volume
from sales_summaries
Now I've figured why I don't get replies, I'm sending again.
Intro:
I have a table that contains much data like this:
SELECT distinct on (date) asx_code,date,open,high,low,close from
sales_summaries where asx_code = 'TLSCA' and date >= '2006-12-01' order
by date, time desc limit 10;
SELECT d
Hi ,
Location: San Diego, CA [You can also TeleCommute but you have to be on the
client side for 2 Weeks in a month]
Duration: 6+ months.
This is Mark with ProV International, This email is in regards to the
requirement we have with one of our direct client in San Diego, CA.
P
Hş,
On Tue, 2007-01-09 at 17:45 -0600, Judith wrote:
> I just want to know if there is some GUI with postgreSQL for Fedore Core 3??
There is pgadmin 1.2.0 (old release, but it works) for Fedora Core 3:
http://www.postgresql.org/ftp/pgadmin3/release/v1.2.0/fc3/
Recent versions of pgadmin3 won't
