Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Parens necessary?
From:   Mark Landry

  Using COALESCE is like using a CASE expression, so you need to use parenthesis...  

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016