pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Roberto Mello <rmello@cc.usu.edu>
To: George A.J <jinujosein@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Case Insensitive comparison
Date: Thu, 25 Sep 2003 20:46:39 -0700
Message-ID: <200309252046.39636.josh@agliodbs.com> (raw)
In-Reply-To: <20030925053008.GC4203@cc.usu.edu>
References: <20030925033550.35699.qmail@web14915.mail.yahoo.com>
	<20030925053008.GC4203@cc.usu.edu>

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



view thread (9+ messages)  latest in thread

Message-ID: <200309252046.39636.josh@agliodbs.com>
Permalink:  ../200309252046.39636.josh@agliodbs.com/
Also on:    postgresql.org/message-id/200309252046.39636.josh@agliodbs.com

 · 

reply

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: josh@agliodbs.com, rmello@cc.usu.edu, jinujosein@yahoo.com
  Subject: Re: Case Insensitive comparison
  In-Reply-To: <200309252046.39636.josh@agliodbs.com>

* 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