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]
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
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
> 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