Re: problems with leading zero's

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Bryan Irvine <bryan(dot)irvine(at)kingcountyjournal(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: problems with leading zero's
Date: 2003-11-19 19:22:10
Message-ID: 20031119192210.GA22998@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, Nov 19, 2003 at 11:07:22 -0800,
Bryan Irvine <bryan(dot)irvine(at)kingcountyjournal(dot)com> wrote:
> I'm having problems with my SQL selecting numbers with preceding zero's
> from a character field.

You want to quote the digits so they get treated as a string instead of
a number which then gets converted to a string.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno LEVEQUE 2003-11-19 19:56:04 Re: problems with leading zero's
Previous Message Bryan Irvine 2003-11-19 19:07:22 problems with leading zero's