[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

XQuery question - feel free to ignore

• To: <xml-dev@l...>
• Subject: XQuery question - feel free to ignore
• From: "Joe Fawcett" <joefawcett@h...>
• Date: Wed, 7 Apr 2004 17:22:48 -0700
• References: <15725CF6AFE2F34DB8A5B4770B7334EE03F9F59F@h...> <5.2.0.9.0.20040407192357.01836920@p...>
• Reply-to: "Joe Fawcett" <joefawcett@h...>

I was hoping someone who uses or intends to use XQuery might have some
experience and/or thoughts on this.
If I have a database that supports XQuery and I construct a query that uses
the following XPath as part of a flower statement:
customer[surname = 'smith']
how would you both want and expect the query to run?
1) Return all customers where surname equalled exactly 'smith' or
2) Follow the datbase matching and return 'Smith' and 'smith' and other case
insensitive strings or
3) I can choose by setting a parameter before running the query which mode
to use

On a similar note if I ask for
customer[age > 20.5]
but age is stored as an integer would you want/expect the same sort of
conversion to be made as the database would (probably error as unable to
implicitly cast) or would you expect the results to be queried as XPath. In
essence where does the filter take place, in the database or on some
imaginary document created by the database containing all customers?


Thanks for you views etc..

Joe Fawcett

• Follow-Ups:
  • RE: XQuery question - feel free to ignore
    • From: "Michael Kay" <michael.h.kay@n...>
  • Re: XQuery question - feel free to ignore
    • From: Liam Quin <liam@w...>

• References:
  • RE: Costs, benefits, and emperors with wardrobe malfunctions - was Re: WS-Emperor naked?
    • From: "Bullard, Claude L (Len)" <clbullar@i...>
  • Re: Converting xml to csv with xslt
    • From: "G. Ken Holman" <gkholman@C...>

• Prev by Date: Re: Converting xml to csv with xslt
• Next by Date: RE: Can anyURI be empty?
• Previous by thread: RE: Converting xml to csv with xslt
• Next by thread: Re: XQuery question - feel free to ignore
• Index(es):
  • Date
  • Thread