Re: Postgresql and bracket expression
Re: Postgresql and bracket expression
- Subject: Re: Postgresql and bracket expression
- From: Arturo Pérez <email@hidden>
- Date: Tue, 13 Jun 2006 21:03:27 -0400
Never saw such a thing before. Is that legal ANSI SQL?
In any case, with the Wonder plugin you can use the regexp operator
that PostgreSQL has:
How do I do regular expression searches? case-insensitive regexp
searching?
PostgreSQL supports the SQL LIKE syntax as well as more general
regular expression searching with the ~ operator. The !~ is the
negated regexp operator. ~* and !~* are the case-insensitive regular
expression operators.
-arturo
On Jun 13, 2006, at 7:54 PM, Mac Dev wrote:
Dear WO-dev gurus,
I am running into a problem and couldn't find any mention in the list
archive or google.
I just upgraded the database from MSSQL 7 to Postgresql 8.1.3. My WO
app works fine except the following problem.
Whenever I have a fetch with an EOQualifier like this:
EOQualifier.qualifierWithQualifierFormat("category_sortName
caseInsensitiveLike '[!-l]*'", null);
I get an empty result set. If I changed [!-l]* to let's say a*, I
would get results.
My question is, how do you use bracket expression with Postgresql in
WO 5.2? If it is not supported, is there an efficient way to achieve
the same thing?
Thank you very much for any insight you may have. I apologize in
advance if this is a stupid question. :p
sincerely,
Nick Yang _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
email@hidden
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden