• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Postgresql and bracket expression
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
References: 
 >Postgresql and bracket expression (From: Mac Dev <email@hidden>)

  • Prev by Date: Postgresql and bracket expression
  • Next by Date: Perforce + XCode + WO?
  • Previous by thread: Postgresql and bracket expression
  • Next by thread: Re: Postgresql and bracket expression
  • Index(es):
    • Date
    • Thread