Archives of the TeradataForum

Message Posted: Mon, 03 Jun 2002 @ 16:43:14 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Thanks Jose for providing another example. It just seems like a pretty lame parser that can't match the 'case' and 'end' keywords without the parens. Even if coalesce() is logically the same as case .. end, the parser doesn't necessarily "know" this during lexical analysis.

I'd also like to see a reference where the (case .. end) || 'string' syntax is documented. It's not in either the Case expression or Conatenation expression sections of the SQL Reference. Also the syntax diagrams don't indicate it.

	<Prev	Next>		<<First	<Prev	Next>	Last>>