473,513 Members | 2,456 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Cardinality

Hello

Maybe somebody know how to construct the cardinality functions of
required for XPath 2.0, XQuery 1.0 and XSLT 2.0 ?

there are three functions normally,

fn:zero-or-one(item,item,...) Returns the argument if it contains
zero or one items, otherwise it raises an error
fn:one-or-more(item,item,...) Returns the argument if it contains one
or more items, otherwise it raises an error
fn:exactly-one(item,item,...) Returns the argument if it contains
exactly one item, otherwise it raises an error

How could I construct them with coding them ?

Aug 28 '06 #1
0 959

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
6711
by: Vissu | last post by:
Hi All, We have one column with low cardinality, 4 or 5 unique values across 50 mil rows. Our query has this colunmn as a predicate. Binary index is not helping. I am tempted to create...
0
1555
by: Dathan Vance Pattishall | last post by:
------=_NextPart_000_00A7_01C34644.9C21B100 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Say I have column A with 10000 distinct values column B and C with 2...
2
10435
by: Rizyak | last post by:
-----Cross posted on comp.databases.ms-sqlserver and microsoft.public.sqlserver.programming----- Can someone please explain cardinality to me? I am having a problem with an insert from a...
2
4670
by: Ihug | last post by:
I have a database table with approx 3 million rows. There are 9 indexes on this table. The command: SHOW INDEX FROM TRAN; Returns results as expected with all indexes some valid "Cardinality"...
2
2158
by: pnichols | last post by:
We have a large select statement being executed statically from an SQL stored procedure, such as: SELECT ...about 100 columns... FROM ...about 30 tables... WHERE ...about 10 predicates... AND...
7
5942
by: janet | last post by:
HI, We had some data which had low cardinality (86) , the count for that table is 9 million rows. How to optimize query which involve joining this table on that column? I'm not sure if...
5
4920
by: MLH | last post by:
Cardinality? I hear it spoken of by MySQL users. Does it matter to MS Access if MySQL tables are attached via ODBC?
2
3381
by: rloef | last post by:
I have a 5.0.15 database with a table with a few million rows and 408 different dates in a date field. If I do 'SHOW INDEXES IN TABLENAME' the output says the cardinality of the DATE index is...
2
5503
by: uwcssa | last post by:
is there a way to see the actual (not just estimated) cost and cardinality at each plan operator? SQL Server and Oracle has such feature but I failed to find a way in DB2 yet (up to V9.5)
0
927
by: db2admin | last post by:
hello, I have compressed table 442992 rows and when i run explain plan on this table for some SQL using this table, i see table scan and cardinality on top of table node as 18458. I am new to...
0
7260
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7160
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7384
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7537
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7525
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5685
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
3222
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1594
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
799
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.