Re: [SQL] CASE not working

2005-03-21 Thread Martín Marqués
El Lun 21 Mar 2005 11:29, Alvaro Herrera escribió: > On Mon, Mar 21, 2005 at 11:18:38AM -0300, Martín Marqués wrote: > > Hey Martin, > > > I have this query which has a CASE in the middle to give me special results. > > The problem is that it doesn't interpret my columns as it should. > > > >

Re: [SQL] CASE not working

2005-03-21 Thread Alvaro Herrera
On Mon, Mar 21, 2005 at 11:18:38AM -0300, Martín Marqués wrote: Hey Martin, > I have this query which has a CASE in the middle to give me special results. > The problem is that it doesn't interpret my columns as it should. > > Here is the porblem: > > siprebi=> SELECT getvencimientosancion(190

[SQL] CASE not working

2005-03-21 Thread Martín Marqués
I have this query which has a CASE in the middle to give me special results. The problem is that it doesn't interpret my columns as it should. Here is the porblem: siprebi=> SELECT getvencimientosancion(190) AS vence, (SELECT codigo FROM sanciones WHERE persona = (SELECT persona FROM usuarios