Re: Case Insensitive comparison

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>, "George A(dot)J" <jinujosein(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Case Insensitive comparison
Date: 2003-09-26 03:46:39
Message-ID: 200309252046.39636.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Roberto,

> > 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().

NULLIF is the converse of COALESCE().

Any idea when you're going to overhaul the CookBook?

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Sydney-Smith 2003-09-26 05:18:27 Date interval
Previous Message Tom Lane 2003-09-26 00:34:46 Re: tsearch2 question