| From: | Thierry Missimilly <THIERRY(dot)MISSIMILLY(at)BULL(dot)NET> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Problem to add a delay to a date |
| Date: | 2003-04-03 11:28:54 |
| Message-ID: | 3E8C1AF6.59D2D1E7@BULL.NET |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| THIERRY.MISSIMILLY.vcf | text/x-vcard | 327 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Haworth | 2003-04-03 11:36:07 | Re: this date format thing. |
| Previous Message | Ulli Mueckstein | 2003-04-03 11:01:16 | call analyze from stored procedure in C |