Postgres Pro
Downloads
Home   >   mailing lists

Re: timestamp out of range while casting return value to function's return type - Mailing list pgsql-general

From Tom Lane
Subject Re: timestamp out of range while casting return value to function's return type
Date
Msg-id 27502.1566609034@sss.pgh.pa.us
Whole thread Raw
In response to timestamp out of range while casting return value to function'sreturn type  (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
Responses Re: timestamp out of range while casting return value to function'sreturn type  (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
List pgsql-general
Tree view 
Thiemo Kellner <thiemo@gelassene-pferde.biz> writes:
> I created a function that ought to return a timestamptz (another  
> likewise timestamp) but calling it, I get mentionied error. What do I  
> miss?

Whether that:

>          return '294277-01-01 00:59:59.999999'::timestamptz;

is in range or not depends on your timezone setting.  It would
be considered in-range in UTC+1 or further east (so that the date
wraps back to 294276AD); in or west of Greenwich, not so much.

> I tried to return a timestamp of the year 2000 to no avail.

Hardly ...

            regards, tom lane

pgsql-general by date:

Previous
From: Thiemo Kellner
Date:
Subject: timestamp out of range while casting return value to function'sreturn type
Next
From: Thiemo Kellner
Date:
Subject: Re: timestamp out of range while casting return value to function'sreturn type