Skip site navigation (1) Skip section navigation (2)

Re: Valor-Maximo

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: "Martin Marques" <martin(at)bugs(dot)unl(dot)edu(dot)ar>
Cc: Kelly González Enríquez <kge_7(at)yahoo(dot)com(dot)mx>, postgresql <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: Valor-Maximo
Date: 2006-03-29 04:35:25
Message-ID: (view raw or whole thread)
Lists: pgsql-es-ayuda
On 3/28/06, Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> wrote:
> On Tue, 28 Mar 2006 10:54:54 -0600 (CST), Kelly González Enríquez <kge_7(at)yahoo(dot)com(dot)mx> wrote:
> >
> >   fila    valor_est
> >   1       9975
> valor_est tiene, por lo que veo, enteros, pero en un mail anterior decis que esta definida como varchar(10). Porque es esto?

en todo caso y si tienes la seguridad que no hay letras por ahi dando vueltas:

select * from est_baszmvt where "valor_est" = (select MAX("valor_est::int4")
from est_baszmvt);

Jaime Casanova

"What they (MySQL) lose in usability, they gain back in benchmarks, and that's
all that matters: getting the wrong answer really fast."
                           Randal L. Schwartz

In response to

pgsql-es-ayuda by date

Next:From: Jaime CasanovaDate: 2006-03-29 04:55:02
Subject: Re: Montar POstgres 8.1x en Servidor Suse 9.2
Previous:From: Jaime CasanovaDate: 2006-03-29 04:29:39
Subject: Re: tipos de tablas e indices

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group