| From: | Patrick Nelson <pnelson(at)neatech(dot)com> |
|---|---|
| To: | "PostgreSQL List (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: RE in WHERE SOLVED |
| Date: | 2002-10-11 16:48:20 |
| Message-ID: | 4165C48DE9A0D211B6400800095C585F172E70@WASHINGTON |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Patrick Nelson wrote:
----------------->>>>
Jean-Luc Lachance wrote:
----------------->>>>
Double up on the back slashes.
SELECT * FROM secure WHERE ~ '^12\\.'
----------------->>>>
That didn't work either...
----------------->>>>
Actually that does work within psql. I was trying from the command line
like:
psql <database> -c "SELECT * FROM <table> WHERE host~'^12\\.'"
which doesn't work. However, if I went into psql and entered the query then
it did work. Guess the bash shell does something to the block...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | snpe | 2002-10-11 16:48:41 | Re: Out of memory error on huge resultset |
| Previous Message | Patrick Nelson | 2002-10-11 16:42:01 | Re: RE in WHERE SOLVED |