470,614 Members | 1,434 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

Using regular expression in query

Hi all,

I need to filter out rows like 'A <number>'
where the second character=space character.

To start with I have the expression: ~* '^A' which will
filter out any row starting with 'A'.
Now there must be something to indicate the space character.
(in Perl '\s' defines <space> but not in Postgres it seems)

Grateful for any help on this!
Jul 19 '05 #1
0 1632

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Brian Richmond | last post: by
3 posts views Thread by James D. Marshall | last post: by
4 posts views Thread by Egyd Csaba | last post: by
6 posts views Thread by rorymo | last post: by
4 posts views Thread by Brian Simmons | last post: by
10 posts views Thread by Julien | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.