MogDB
Ecological Tools
Doc Menu

Encrypted Equality Functions

  • byteawithoutorderwithequalcolin(cstring)

    Description: Converts input data to the internal byteawithoutorderwithequalcol format.

    Parameter type: cstring

    Return type: byteawithoutorderwithequalcol

  • byteawithoutorderwithequalcolout(byteawithoutorderwithequalcol)

    Description: Converts internal data of the byteawithoutorderwithequalcol type to data of the cstring type.

    Parameter type: byteawithoutorderwithequalcol

    Return type: cstring

  • byteawithoutorderwithequalcolsend(byteawithoutorderwithequalcol)

    Description: Converts data of the byteawithoutorderwithequalcol type to data of the bytea type.

    Parameter type: byteawithoutorderwithequalcol

    Return type: bytea

  • byteawithoutorderwithequalcolrecv(internal)

    Description: Converts data of the byteawithoutorderwithequalcol type to data of the byteawithoutorderwithequalcol type.

    Parameter type: internal

    Return type: byteawithoutorderwithequalcol

  • byteawithoutorderwithequalcoltypmodin(_cstring)

    Description: Converts data of the byteawithoutorderwithequalcol type to data of the byteawithoutorderwithequalcol type.

    Parameter type: _cstring

    Return type: int4

  • byteawithoutorderwithequalcoltypmodout(int4)

    Description: Converts data of the int4 type into data of the cstring type.

    Parameter type: int4

    Return type: cstring

  • byteawithoutordercolin(cstring)

    Description: Converts input data to the internal byteawithoutordercolin format.

    Parameter type: cstring

    Return type: byteawithoutordercol

  • byteawithoutordercolout(byteawithoutordercol)

    Description: Converts internal data of the byteawithoutordercol type to data of the cstring type.

    Parameter type: byteawithoutordercol

    Return type: cstring

  • byteawithoutordercolsend(byteawithoutordercol)

    Description: Converts data of the byteawithoutordercol type to data of the bytea type.

    Parameter type: byteawithoutordercol

    Return type: bytea

  • byteawithoutordercolrecv(internal)

    Description: Converts data of the byteawithoutordercol type to data of the byteawithoutordercol type.

    Parameter type: internal

    Return type: byteawithoutordercol

  • byteawithoutorderwithequalcolcmp(byteawithoutorderwithequalcol, byteawithoutorderwithequalcol)

    Description: Compares two byteawithoutorderwithequalcol data sizes. If the first data size is smaller than the second one, -1 is returned. If the first data size is equal to the second one, 0 is returned. If the first data size is larger than the second one, 1 is returned.

    Parameter type: byteawithoutorderwithequalcol, byteawithoutorderwithequalcol

    Return type: int4

  • byteawithoutorderwithequalcolcmpbytear(byteawithoutorderwithequalcol, bytea)

    Description: Compares the byteawithoutorderwithequalcol and bytea data sizes. If the first data size is smaller than the second one, -1 is returned. If the first data size is equal to the second one, 0 is returned. If the first data size is larger than the second one, 1 is returned.

    Parameter type: byteawithoutorderwithequalcol, bytea

    Return type: int4

  • byteawithoutorderwithequalcolcmpbyteal(bytea, byteawithoutorderwithequalcol)

    Description: Compares the bytea and byteawithoutorderwithequalcol data sizes. If the first data size is smaller than the second one, -1 is returned. If the first data size is equal to the second one, 0 is returned. If the first data size is larger than the second one, 1 is returned.

    Parameter type: byteawithoutorderwithequalcol, bytea

    Return type: int4

  • byteawithoutorderwithequalcoleq(byteawithoutorderwithequalcol, byteawithoutorderwithequalcol)

    Description: Compares two byteawithoutorderwithequalcol data records. If they are the same, true is returned. Otherwise, false is returned.

    Parameter type: byteawithoutorderwithequalcol, bytea

    Return type: Boolean

  • byteawithoutorderwithequalcoleqbyteal(bytea, byteawithoutorderwithequalcol)

    Description: Compares the bytea and byteawithoutorderwithequalcol data records. If they are the same, true is returned. Otherwise, false is returned.

    Parameter type: bytea, byteawithoutorderwithequalcol

    Return type: Boolean

  • byteawithoutorderwithequalcoleqbytear(byteawithoutorderwithequalcol, bytea)

    Description: Compares the byteawithoutorderwithequalcol and bytea data records. If they are the same, true is returned. Otherwise, false is returned.

    Parameter type: byteawithoutorderwithequalcol, bytea

    Return type: Boolean

  • byteawithoutorderwithequalcolne(byteawithoutorderwithequalcol, byteawithoutorderwithequalcol)

    Description: Compares two byteawithoutorderwithequalcol data records. If they are different, true is returned. Otherwise, false is returned.

    Parameter type: byteawithoutorderwithequalcol, byteawithoutorderwithequalcol

    Return type: Boolean

  • byteawithoutorderwithequalcolnebyteal(bytea, byteawithoutorderwithequalcol)

    Description: Compares bytea with byteawithoutorderwithequalcol. If they are the same, true is returned. Otherwise, false is returned.

    Parameter type: bytea, byteawithoutorderwithequalcol

    Return type: Boolean

  • byteawithoutorderwithequalcolnebytear(byteawithoutorderwithequalcol, bytea)

    Description: Compares the byteawithoutorderwithequalcol and bytea data records. If they are the same, true is returned. Otherwise, false is returned.

    Parameter type: byteawithoutorderwithequalcol, bytea

    Return type: Boolean

  • hll_hash_byteawithoutorderwithequalcol(byteawithoutorderwithequalcol)

    Description: Returns the hll hash value of byteawithoutorderwithequalcol.

    Parameter type: byteawithoutorderwithequalcol

    Return type: hll_hashval

    The implementation of byteawithoutorderwithequalcolin searches for CEK and determines whether it is a normal encrypted data type. Therefore, an error is reported when the user directly uses the function.

    mogdb=# SELECT * FROM byteawithoutorderwithequalcolsend('\x907219912381298461289346129'::byteawithoutorderwithequalcol);
    ERROR:  cek with OID 596711794 not found
    LINE 1: SELECT * FROM byteawithoutorderwithequalcolsend('\x907219912...
                                                            ^
    mogdb=# SELECT * FROM byteawithoutordercolout('\x90721901999999999999912381298461289346129');
    ERROR:  cek with OID 2566986098 not found
    LINE 1: SELECT * FROM byteawithoutordercolout('\x9072190199999999999...
           
    SELECT * FROM byteawithoutorderwithequalcolrecv('\x90721901999999999999912381298461289346129'::byteawithoutorderwithequalcol);
    ERROR:  cek with OID 2566986098 not found
                                               ^
    mogdb=# SELECT * FROM byteawithoutorderwithequalcolsend('\x90721901999999999999912381298461289346129'::byteawithoutorderwithequalcol);
    ERROR:  cek with OID 2566986098 not found
    LINE 1: SELECT * FROM byteawithoutorderwithequalcolsend('\x907219019...
                                                            ^