| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Pablo Braulio <brulics(at)gmail(dot)com> |
| Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: No acierto usando CASE. |
| Date: | 2007-12-04 12:24:10 |
| Message-ID: | 20071204122410.GB4727@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
Pablo Braulio escribió:
> No he usado mucho CASE en un select, por lo que no doy correctamente con
> la sintaxis.
>
> Si pongo en un select esto:
... CASE WHEN instmant='I' THEN 'Instalación' ELSE 'Mantenimiento' END ...
Te falta el END, y no necesitas parentesis.
--
Alvaro Herrera http://www.PlanetPostgreSQL.org/
"Now I have my system running, not a byte was off the shelf;
It rarely breaks and when it does I fix the code myself.
It's stable, clean and elegant, and lightning fast as well,
And it doesn't cost a nickel, so Bill Gates can go to hell."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alejandro D. Burne | 2007-12-04 12:32:55 | Re: No acierto usando CASE. |
| Previous Message | Pablo Braulio | 2007-12-04 12:19:29 | No acierto usando CASE. |