Re: DateDiff, IsNull? - Mailing list pgsql-sql

From Alan Gutierrez
Subject Re: DateDiff, IsNull?
Date
Msg-id Pine.WNT.4.33.0108140634400.1680-100000@CX1198465-B
Whole thread Raw
In response to DateDiff, IsNull?  ("Bill" <bchie@opensys.com.hk>)
Responses Re: Re: DateDiff, IsNull?
Re: Re: DateDiff, IsNull?
List pgsql-sql
On Tue, 14 Aug 2001, Bill wrote:

> Hello all,
>
>   I am a newbie to postgreSQL, is it possible to write a "DateDiff",
> "IsNull" function work same as the one in SQL Server and are there and
> sample out there? And is it possible to override the existing function and
> operator like "+" to become a concate?

I don't know what IsNull does but:

template1=> select coalesce(NULL, 'Hello');case
-------Hello
(1 row)

I do know what DateDiff does:

template1=> select '2001-08-14'::date - '6 weeks'::interval;       ?column?
------------------------2001-07-03 00:00:00-05
(1 row)

Overloading operators? *Please* tell me that this is impossible.

Alan Gutierrez





pgsql-sql by date:

Previous
From: Justin Clift
Date:
Subject: Re: [GENERAL] Re: Mirroring the database?
Next
From: "Michael Ansley (UK)"
Date:
Subject: RE: Re: Are circular REFERENCES possible ?