From: | Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | time conversion fuinctions |
Date: | 2006-10-07 08:13:10 |
Message-ID: | 1160208790.4482.17.camel@zorro.isa-geek.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All,
Is this the expected result?
The question particularly apply to the last SELECT. I'd expected it to
return boolean value just like in the second example below. It returns
nothing instead, and does not rise an error either. Is this the correct
behavior?
But also, is it correct for a function date(timestamp) to return one row
of *nothing*?
----------------postgres v8.1.4----------------------------
# SELECT timestamp 'today';
timestamp
---------------------
2006-10-07 00:00:00
(1 row)
# SELECT date(timestamp 'today') <> date(timestamp 'yesterday');
?column?
----------
t
(1 row)
# SELECT timestamp 'infinity';
timestamp
-----------
infinity
(1 row)
# SELECT timestamp '-infinity';
timestamp
-----------
-infinity
(1 row)
# SELECT date(timestamp 'infinity');
date
------
(1 row)
# SELECT date(timestamp '-infinity');
date
------
(1 row)
# SELECT date(timestamp '-infinity') <> date(timestamp 'infinity');
?column?
----------
(1 row)
---------------------END----------------------
--
-R
From | Date | Subject | |
---|---|---|---|
Next Message | Emanuele Rocca | 2006-10-07 10:12:00 | Re: URGENT - startup process (PID 29541) was terminated by signal 6 |
Previous Message | Rafal Pietrak | 2006-10-07 07:43:50 | predefined functions |