From: | Martin Gainty <mgainty(at)hotmail(dot)com> |
---|---|
To: | <ml-postgresql-20081012-3518(at)gheift(dot)de>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: infinity interval |
Date: | 2008-12-21 01:27:45 |
Message-ID: | BLU142-W26742E6E98D8FA845821DBAEEE0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Gerhard-
did you try to use a PL/SQL Block to initialize the necessary integer values in your declare block e.g.
DECLARE
SET @INT_MIN = INTEGER ( min ); --Min Value
SET @INT_MAX = INTEGER ( max ); --Max value
BEGIN
....
END;
http://pgscript.projects.postgresql.org/SCRIPT.html
HTH
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.
> Date: Sun, 21 Dec 2008 00:52:04 +0100
> From: ml-postgresql-20081012-3518(at)gheift(dot)de
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] infinity interval
>
> Hello,
>
> how can I store an infinity value into an interval? I want to store
> offsets to a timestamp, and for some cases i need +infinity and
> -infinity as result.
>
> I want to make something like this:
> SELECT now() + 'infinity'::interval;
>
> This should return 'infinity'::timestamp.
>
> Is it possible?
>
> Thanks,
> Gerhard
_________________________________________________________________
Send e-mail faster without improving your typing skills.
http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_speed_122008
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2008-12-21 03:30:29 | Re: infinity interval |
Previous Message | Richard Broersma | 2008-12-21 01:26:29 | Re: infinity interval |