Data conversion in query

From: Tad Marko <tad(at)tadland(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Data conversion in query
Date: 2003-03-27 19:43:10
Message-ID: Pine.LNX.4.44.0303271337220.15434-100000@minime.tadland.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm having a small difficulty that I am hopeful there is a simple solution
for. Basically, I am doing a join on a column that is numeric in one
database but a string in the other. Something like:

...WHERE a.numeric_zipcode=b.string_zipcode::integer...

The problem is that occasionally the string zip field has some
non-numeric characters. Unfortunatley, I cannot control the sanity of the
string zip field. The question is if there is any way that in the same
query I can filter out the rows that have non-number characters in the zip
field?

Thanks for any thoughts,

Tad

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2003-03-27 19:56:14 Re: Data conversion in query
Previous Message Tom Lane 2003-03-27 19:34:50 Re: Possible bug in date(timestamptz)?