How to build a query - Mailing list pgsql-novice

From Krzysztof Walkiewicz
Subject How to build a query
Date
Msg-id 4B8CE341.9020701@op.pl
Whole thread Raw
Responses Re: How to build a query  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: How to build a query  (Thom Brown <thombrown@gmail.com>)
List 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

pgsql-novice by date:

Previous
From: "Eric Comeau"
Date:
Subject: Re: are primary keys always 'needed'
Next
From: "A. Kretschmer"
Date:
Subject: Re: How to build a query