Re: Case Insensitive comparison - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Case Insensitive comparison
Date
Msg-id 200309252046.39636.josh@agliodbs.com
Whole thread Raw
In response to Re: Case Insensitive comparison  (Roberto Mello <rmello@cc.usu.edu>)
Responses Re: Case Insensitive comparison  (Roberto Mello <rmello@cc.usu.edu>)
List 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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: tsearch2 question
Next
From: "Richard Sydney-Smith"
Date:
Subject: Date interval