From: | Wilton Wonrath <wrwonrath(at)yahoo(dot)com(dot)br> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Range of caracters |
Date: | 2007-08-07 17:07:42 |
Message-ID: | 603019.54350.qm@web34314.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello,
I have a doubt about a query using a range of caracters. Example:
Data Table
Inicial ------------- Final
9C2HB02107R008000 9C2HB02107R008200
FAIXA1 FAIXA100
I´m doing the following query:
SELECT recallfxchassi.* FROM recallfxchassi
LEFT JOIN recall ON recallfxchassi.idrecall = recall.id WHERE
('FAIXA2' BETWEEN chassiinicial AND chassifinal);
This is not returning anything. I believe that is because it´s check´s caracter by caracter and 2 is bigger than 1. But in a real situation I will need that return something (FAIXA2 is between FAIXA1 and FAIXA100).
Does anyone knows if exists some way or command in PostgreSQL that could solve this "problem" ?
Thanks.
Alertas do Yahoo! Mail em seu celular. Saiba mais em http://br.mobile.yahoo.com/mailalertas/
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Glaesemann | 2007-08-07 17:49:42 | Re: Adding NOT NULL columns in PostgreSQL 7.4? |
Previous Message | Michael Eshom | 2007-08-07 16:54:05 | Adding NOT NULL columns in PostgreSQL 7.4? |