Received: from dep1.fciencias.unam.mx (dep1.fciencias.unam.mx
	[132.248.133.210])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id f7EGDgP69192
	for <pgsql-sql@postgresql.org>; Tue, 14 Aug 2001 12:13:42 -0400 (EDT)
	(envelope-from masm@fciencias.unam.mx)
Received: (from masm@localhost)
	by dep1.fciencias.unam.mx (8.11.2/8.11.2) id f7EG5ii10030;
	Tue, 14 Aug 2001 11:05:44 -0500
X-Authentication-Warning: dep1.fciencias.unam.mx: masm set sender to
	masm@fciencias.unam.mx using -f
To: Alan Gutierrez <alangutierrez@hotmail.com>
Cc: Bill <bchie@opensys.com.hk>, pgsql-sql@postgresql.org
Subject: Re: Re: DateDiff, IsNull?
References: <9lb25o$psq$1@news.tht.net>
	<Pine.WNT.4.33.0108140634400.1680-100000@CX1198465-B>
Date: 14 Aug 2001 11:00:07 -0500
In-Reply-To: Alan Gutierrez's message of "Tue, 14 Aug 2001 06:51:33 +0000"
Message-ID: <m3u1za1vjs.fsf@dep1.fciencias.unam.mx>
From: Manuel Sugawara <masm@fciencias.unam.mx>
User-Name: Manuel Sugawara
User-Mail-Address: masm@fciencias.unam.mx
Lines: 18
User-Agent: Gnus/5.0807 (Gnus v5.8.7) XEmacs/21.1 (Cuyahoga Valley)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Archive-Number: 200108/189
X-Sequence-Number: 4414

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=#