select ... from ... where ... ~* 'C++'

From: Martin Dolog <dolog(at)mcprogress(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: select ... from ... where ... ~* 'C++'
Date: 1999-09-04 14:33:28
Message-ID: 37D12DB8.F94227A3@mcprogress.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


hi *,

PLease, how can I make case insensitive query
which work with string like 'C++' too ?

select something from something_t where some ~* 'C++'

doesn't work!
I got following error message:

"ERROR: regcomp failed with error repetition-operator operand invalid"

I am running on Linux/Redhat6/postgresql6.5 compiled
with --enable-locale flag.

Thank you very much for help.

Martin

--

#md

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message tjk@tksoft.com 1999-09-04 17:38:40 Re: [SQL] select ... from ... where ... ~* 'C++'
Previous Message Clayton Cottingham 1999-09-04 00:52:04 any info on sql/database admin courses