Problem to add a delay to a date - Mailing list pgsql-general

From Thierry Missimilly
Subject Problem to add a delay to a date
Date
Msg-id 3E8C1AF6.59D2D1E7@BULL.NET
Whole thread Raw
Responses Re: Problem to add a delay to a date  (Richard Huxton <dev@archonet.com>)
Re: Problem to add a delay to a date  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Hi,

I try to create a function in charge of adding a delay to a timestamp.
Here are the stange results on Postgres 7.3.1.
working with psql :

test=# select now() + '60' as time;
                time
--------------------------------------
2003-03-24 16:04:53.8680551+01
(1 row)


and when i want to create a function :

test=# create function addtime() returns timestamp as 'select now() +
''60'' ' language 'sql';
ERROR: return type mismatch in function: declared to return timestamp
without time zone, returns timestamp with time zone


Where is the error .

    Thierry

Attachment

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: Postgresql capabilities question
Next
From: "Peter Haworth"
Date:
Subject: Re: this date format thing.