Re: Re: DateDiff, IsNull?

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: Alan Gutierrez <alangutierrez(at)hotmail(dot)com>
Cc: Bill <bchie(at)opensys(dot)com(dot)hk>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Re: DateDiff, IsNull?
Date: 2001-08-14 16:00:07
Message-ID: m3u1za1vjs.fsf@dep1.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Alan Gutierrez <alangutierrez(at)hotmail(dot)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=#

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-08-14 19:15:52 Deadlocks? What happened to MVCC?
Previous Message Ross J. Reedstrom 2001-08-14 15:34:51 Re: Re: DateDiff, IsNull?