xor()

Description:

Perform XOR operation on integers.

Syntax:

xor(xi,…)

xor(A)

 

Note:

The function performs XOR operation on integers. It supports a decimal without the fractional part.

Parameters:

A	A sequence
xi	The numerical expression based on which you perform the XOR operation

Return value:

An integer

Example:

xor(6,11)	13
xor([6,11])		1
xor(decimal(6),decimal(11))		13, which is the decimal type

xunion()

Here’s how to use xunion() function.

A.xunion()

Description:

Generate a new sequence by uniting and rearranging distinct members in each of a sequence’s sub-sequences.

Syntax:

A.xunion()

Note:

The function forms a new sequence by uniting and rearranging distinct members in each of sequence A’s sub-sequences. Same members after the distinct operation won’t be removed.

Parameters:

A	A sequence consisting of sequences

Return value:

A sequence

Example:

	A
1	=[[1,2,3,3,4],[1,1,3]].xunion()	[2,3,4,1]
2	=[[1,2,3,3,4],[1,1,3],[4]].xunion()	[2,3,1]
3	=[[1,2],[]].xunion()	[1,2]
4	=demo.query("select top 2 * from EMPLOYEE")
5	=demo.query("select top 1 * from EMPLOYEE")
6	=[A4,A5].xunion()	A4 and A5 come from two table sequences stored in different places, so same records are treated as different members

Related functions:

A.union()

A.conj()

A.isect()

A.diff()

A.xunion(x)

Description:

Calculate an expression with each member of every sub-sequence of a sequence to generate a new sequence by uniting and rearranging distinct members in each of the resulting sub-sequences.

Syntax:

A.xunion(x)

Note:

Over sequence A whose members are also sequences, the function calculates expression x with each member of every sub-sequence, and forms a new sequence by uniting and rearranging distinct members in each of the resulting sub-sequences. Same members after the distinct operation won’t be removed.

Parameters:

A	A sequence consisting of sequences
x	An expression whose value is a sequence

Return value:

A sequence

Example:

	A
1	=demo.query("select EID,SURNAME,GENDER from EMPLOYEE where GENDER = 'M' and EID < 20")
2	=demo.query("select EID,SURNAME,GENDER from EMPLOYEE where GENDER = 'F' and EID < 20")
3	=[A1,A2].xunion(~.(SURNAME))	Rearranging distinct members in A1 and A2 to generate a new sequence; Same members after the distinct operation won’t be removed

Related functions:

A.xunion()