How to build a query

From: Krzysztof Walkiewicz <bars0(at)op(dot)pl>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to build a query
Date: 2010-03-02 10:06:57
Message-ID: 4B8CE341.9020701@op.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello everyone!

In my table I have a column phone_numbers (varchar 30) that the
telephone numbers are stored in the following way (13 signs with spaces):

032 321 24 25
032 341 24 85
032 345 24 87

But in the same column there is also few hundred of mobile numbers that
i want to copy to another table. They were written in the following way
(11 signs with spaces):

606 605 504
506 504 548
879 504 152

Now I have a question: how to built a query that will give me only the
rows that are shorter than 13 signs (and maybe longer than 13 to check
if there is no mistakes)?

Regards,
Krzysztof Walkiewicz

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thom Brown 2010-03-02 10:21:34 Re: How to build a query
Previous Message Eric Comeau 2010-03-01 13:05:41 Re: are primary keys always 'needed'