Posix the tool to use?

From: Romain Billon-Grand <rbgrbg(at)free(dot)fr>
To: Forum postgres debutants <pgsql-novice(at)postgresql(dot)org>
Subject: Posix the tool to use?
Date: 2012-10-07 21:39:00
Message-ID: COL118-W1120A88761CEE572BD5776CE890@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Good eveningAs a novice with postgres, I am not even sure to be on the good way for probably quite a basic query...I am trying to retrieve all rows where one of the text column is a code made of 4 letters followed by 3 numbers such as "LFFA002" or "QSZT123", and of course only them. Other rows from the table are empty, or containing some short sentences, or single letters between brackets. To heterogeneous to be a way to take the problem the other side (that is why I need to clean this ~26000 row table...). But I barely understand anything to Posix or regular expressions in the postgres documentation, even though I feel those could be the tools I need for my WHERE statement...Would you please tell me how to code this? Or better, help me finding a tutorial I could understand(=dummy-adapted!!)? (Even better if it is in French or Spanish, far more natural than english for me!)BestsRomain Billon-Grand

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Kupershmidt 2012-10-07 22:07:54 Re: Posix the tool to use?
Previous Message Andrej 2012-10-04 00:31:22 Re: Using Different Ports for Multiple PosgreSQL Installations: Any Issues?