1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br
Cookies Anuncie aqui Patrocinador Anuncios

Error on an IF function format SQL: Error Not Supported BOOL, STRING, BOOL, only IF(BOOL, ANY,...

Discussão em 'Outras Linguagens' iniciado por Stack, Janeiro 27, 2021.

  1. Stack

    Stack Membro Participativo

    I'm trying to write an IF statement in SQL, and it's throwing an error about the supported format


    SQL_ANALYSIS_ERROR: No matching signature for function IF for argument types: BOOL, BOOL, STRING. Supported signature: IF(BOOL, ANY, ANY)
    ​

    Code: IF(field1 = 'string_1', field2 , 'string_2') AS field_name

    This should meet the requirement of BOOL, ANY, ANY....but for whatever reason it's not. Anyone have suggestions? Or am I missing something?

    Continue reading...
    Stack, Janeiro 27, 2021
    #1

Compartilhe esta Página