Re: What err ???

From: Masaru Sugawara <rk73(at)sea(dot)plala(dot)or(dot)jp>
To: "Robson Martins" <robson-martins(at)bol(dot)com(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: What err ???
Date: 2002-06-07 15:23:30
Message-ID: 20020608002218.250E.RK73@sea.plala.or.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Thu, 6 Jun 2002 17:43:28 -0300
"Robson Martins" <robson-martins(at)bol(dot)com(dot)br> wrote:

> What err ???
>
> SELECT RazaoSocial + ' - ' + Iif(Bairro Is Null,'',Bairro + ' ') + CGCCli As Coluna FROM Clientes WHERE RazaoSocial Like '%A%'
>

Uh, there is no error in MS Access, but are two errors in PG: "+"and "iif()".
You need to use "||" and "CASE WHEN ... THEN ... END". See docs.

Regard,
Masaru Sugawara

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2002-06-07 15:49:26 Re: What err ???
Previous Message Ross J. Reedstrom 2002-06-07 14:37:08 Re: What err ???