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

From Manuel Sugawara
Subject Re: Re: DateDiff, IsNull?
Date
Msg-id m3u1za1vjs.fsf@dep1.fciencias.unam.mx
Whole thread Raw
In response to DateDiff, IsNull?  ("Bill" <bchie@opensys.com.hk>)
List pgsql-sql
Alan Gutierrez <alangutierrez@hotmail.com> writes:

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

yes, it is :-)

masm=# create function concat (text,text) returns text as 'select $1 || $2 as result' language 'sql' with
(iscachable);
CREATE
masm=# create operator + (procedure = concat, leftarg = text, rightarg = text);
CREATE
masm=# select 'Manuel '+'Sugawara';   ?column?     
-----------------Manuel Sugawara
(1 row)

masm=#


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: DateDiff, IsNull?
Next
From: Horst Herb
Date:
Subject: how to use record type