Re: datetimeField = datetimeField - '30minutes'::timespan in psql 7.0 or above - Mailing list pgsql-admin

bangh <banghe@baileylink.net> writes:
> while if you use type timestamp, instead of datetime
> timestampField = timestampField - '30minutes'::interval
>  you will get error msg.:
> No such function 'datetime_stamp' with the specified attributes

I see no such problem in either 7.0 or 7.1 ...

regression=# create table foo1 (f1 timestamp);
CREATE
regression=# insert into foo1 values(now());
INSERT 832069 1
regression=# update foo1 set f1 = f1 - '30minutes'::interval;
UPDATE 1
regression=#

            regards, tom lane