Re: [ADMIN] Group By Time Stamp

2002-03-24 Thread Morten Sickel
> From: Ariunbold Gerelt-Od [mailto:[EMAIL PROTECTED]] > Hi, > > I have a table Answers with fields answer_id > integer,time_stamp timestamp. > > How can I create a query that gives a sum of answer_id=ID > ,but in every > 2 hours. > What you probably need is the function extract(hour from ti

[ADMIN] Group By Time Stamp

2002-03-24 Thread Ariunbold Gerelt-Od
Hi, I have a table Answers with fields answer_id integer,time_stamp timestamp. How can I create a query that gives a sum of answer_id=ID ,but in every 2 hours. For example: answer_sum time_stamp 10 2002-03-24 20-22 12 2002-03-24 22-24 20 2002-03-25 00-02 4

Re: [ADMIN] no drop column?!

2002-03-24 Thread Jyry Kuukkanen
On Sun, 24 Mar 2002, Lucas Rockwell wrote: > bavc=> alter table staff drop column date_created cascade; > ERROR: ALTER TABLE / DROP COLUMN is not implemented > > is this true???!!! i am using PostgreSQL 7.2. > > -lucas Hello lucas Yes, it is true -- with Pgsql 7.3, too. There is a way to get

[ADMIN] no drop column?!

2002-03-24 Thread Lucas Rockwell
bavc=> alter table staff drop column date_created cascade; ERROR: ALTER TABLE / DROP COLUMN is not implemented is this true???!!! i am using PostgreSQL 7.2. -lucas Lucas Rockwell UAS Systems Group 510.642.6465 [EMAIL PROTECTED]