Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > Oh, and I personally think DECODE is fine, even if it partly duplicates > > something we already have. I was just asking to make sure everyone else > > was OK before I applied it. > > I would rather not have a useless variant spelling of CASE ... > LEAST/GREATEST at least do something that's a bit hard to do otherwise.
OK, I will apply the LEAST/GREATEST parts and see if others can argue for decode(). -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
