Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 26 Apr 2005 @ 08:41:25 GMT


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


Subj:   Re: Strange syntax on in clauses
 
From:   Victor Sokovin

  Is this type of concatenation limited to IN-Clauses?  


  Because  


          > Select '01' '02'
  is resulting in '01' with the column name of '02'?  


Just to add to the confusion ...

     SELECT '01' '02'
     FROM dual

is not recognized as valid syntax by Oracle.

However,

     SELECT '01' '02' ,

if run on Sybase or SQL Server, returns 01 in column 02. If I omit the blank between '01' and '02', than the output is the same on the three databases: 01'02.

Neither Oracle, SQL Server or Sybase seem to understand the IN-list syntax like IN ('01' '02','03'), which Teradata manages to parse, as you have noticed. They all generate an SQL error. With the blank omitted, they are happy to parse it. So, it looks like Teradata might be ahead of the competition in this area of ANSI compliance (at least by 3:1), if their interpretation of the ANSI recommendations is correct, of course. I don't have access to the ANSI docs right now but will be able to look them up early next week.


Regards,

Victor



     
  <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: 15 Jun 2023