By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,512 Members | 806 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,512 IT Pros & Developers. It's quick & easy.

Using regular expression in query

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.