time conversion fuinctions

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

Responses

Browse pgsql-general by date

  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