From: Bruno Wolff III <bruno@wolff.to>
To: Roberto Mello <rmello@cc.usu.edu>
Cc: George A.J <jinujosein@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Case Insensitive comparison
Date: Thu, 25 Sep 2003 08:20:46 -0500
Message-ID: <20030925132046.GA27357@wolff.to> (raw)
In-Reply-To: <20030925053008.GC4203@cc.usu.edu>
References: <20030925033550.35699.qmail@web14915.mail.yahoo.com>
<20030925053008.GC4203@cc.usu.edu>
On Wed, Sep 24, 2003 at 23:30:08 -0600,
Roberto Mello <rmello@cc.usu.edu> wrote:
> On Wed, Sep 24, 2003 at 08:35:50PM -0700, George A.J wrote:
>
> > Another problem is in creating function...
> > How can i create a function that accept and return any type. the type "any" is not allowing as parameter or return type. Is it possible? i want to create a function similar to NULLIF().
>
> Use the standard coalesce().
coalesce is used to do the inverse of nullif. Postgres also has a nullif
function.
I suspect that he relly doesn't want to use either of those, but instead
wants to have some function that returns the same type as its argument
without having to write one function for each different type. There is
something along those lines coming in 7.4.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, rmello@cc.usu.edu, jinujosein@yahoo.com
Subject: Re: Case Insensitive comparison
In-Reply-To: <20030925132046.GA27357@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox