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

Re: XQuery question - feel free to ignore

• To: xml-dev@l...
• Subject: Re: XQuery question - feel free to ignore
• From: Liam Quin <liam@w...>
• Date: Thu, 8 Apr 2004 03:53:26 -0400
• In-reply-to: <BAY9-DAV42qte4xon7f00021518@h...>
• References: <15725CF6AFE2F34DB8A5B4770B7334EE03F9F59F@h...> <5.2.0.9.0.20040407192357.01836920@p...> <BAY9-DAV42qte4xon7f00021518@h...>
• User-agent: Mutt/1.5.5.1+cvs20040105i

On Wed, Apr 07, 2004 at 05:22:48PM -0700, Joe Fawcett wrote:
> 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

(3) - in partcular, see the XPath and Functions and Operators
      descriptions of collations and of equality.  (1) will
      generally be the default.

> 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

Yes because you can compare an integer and a decimal.

XQuery operates on instances of the XPath 2 Data Model.  It's up
to the implementor to map correctly from the database into the
data model.  The implementation can do the casting anywhere it
likes - it should have all the information it needs to make the
decision -- but conceptually it happens on data model instances.

Liam

-- 
Liam Quin, W3C XML Activity Lead, http://www.w3.org/People/Quin/
http://www.holoweb.net/~liam/

• 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...>
  • XQuery question - feel free to ignore
    • From: "Joe Fawcett" <joefawcett@h...>

• Prev by Date: Re: XML-appropriate editing data structures
• Next by Date: Re: XML-appropriate editing data structures
• Previous by thread: XQuery question - feel free to ignore
• Next by thread: RE: XQuery question - feel free to ignore
• Index(es):
  • Date
  • Thread