Header And Logo

PostgreSQL
| The world's most advanced open source database.

Data Structures | Functions | Variables

btree_date.c File Reference

#include "postgres.h"
#include "btree_gist.h"
#include "btree_utils_num.h"
#include "utils/date.h"
Include dependency graph for btree_date.c:

Go to the source code of this file.

Data Structures

struct  dateKEY

Functions

 PG_FUNCTION_INFO_V1 (gbt_date_compress)
 PG_FUNCTION_INFO_V1 (gbt_date_union)
 PG_FUNCTION_INFO_V1 (gbt_date_picksplit)
 PG_FUNCTION_INFO_V1 (gbt_date_consistent)
 PG_FUNCTION_INFO_V1 (gbt_date_distance)
 PG_FUNCTION_INFO_V1 (gbt_date_penalty)
 PG_FUNCTION_INFO_V1 (gbt_date_same)
Datum gbt_date_compress (PG_FUNCTION_ARGS)
Datum gbt_date_union (PG_FUNCTION_ARGS)
Datum gbt_date_picksplit (PG_FUNCTION_ARGS)
Datum gbt_date_consistent (PG_FUNCTION_ARGS)
Datum gbt_date_distance (PG_FUNCTION_ARGS)
Datum gbt_date_penalty (PG_FUNCTION_ARGS)
Datum gbt_date_same (PG_FUNCTION_ARGS)
static bool gbt_dategt (const void *a, const void *b)
static bool gbt_datege (const void *a, const void *b)
static bool gbt_dateeq (const void *a, const void *b)
static bool gbt_datele (const void *a, const void *b)
static bool gbt_datelt (const void *a, const void *b)
static int gbt_datekey_cmp (const void *a, const void *b)
static float8 gdb_date_dist (const void *a, const void *b)
 PG_FUNCTION_INFO_V1 (date_dist)
Datum date_dist (PG_FUNCTION_ARGS)

Variables

static const gbtree_ninfo tinfo

Function Documentation

Datum date_dist ( PG_FUNCTION_ARGS   ) 

Definition at line 120 of file btree_date.c.

References Abs, date_mi(), DatumGetInt32, DirectFunctionCall2, PG_GETARG_DATUM, and PG_RETURN_INT32.

{
    /* we assume the difference can't overflow */
    Datum       diff = DirectFunctionCall2(date_mi,
                                           PG_GETARG_DATUM(0),
                                           PG_GETARG_DATUM(1));

    PG_RETURN_INT32(Abs(DatumGetInt32(diff)));
}

Datum gbt_date_compress ( PG_FUNCTION_ARGS   ) 

Definition at line 138 of file btree_date.c.

References gbt_num_compress(), PG_GETARG_POINTER, and PG_RETURN_POINTER.

{
    GISTENTRY  *entry = (GISTENTRY *) PG_GETARG_POINTER(0);
    GISTENTRY  *retval = NULL;

    PG_RETURN_POINTER(gbt_num_compress(retval, entry, &tinfo));
}

Datum gbt_date_consistent ( PG_FUNCTION_ARGS   ) 

Definition at line 149 of file btree_date.c.

References DatumGetPointer, gbt_num_consistent(), GIST_LEAF, GISTENTRY::key, dateKEY::lower, GBT_NUMKEY_R::lower, PG_GETARG_DATEADT, PG_GETARG_POINTER, PG_GETARG_UINT16, PG_RETURN_BOOL, dateKEY::upper, and GBT_NUMKEY_R::upper.

{
    GISTENTRY  *entry = (GISTENTRY *) PG_GETARG_POINTER(0);
    DateADT     query = PG_GETARG_DATEADT(1);
    StrategyNumber strategy = (StrategyNumber) PG_GETARG_UINT16(2);

    /* Oid      subtype = PG_GETARG_OID(3); */
    bool       *recheck = (bool *) PG_GETARG_POINTER(4);
    dateKEY    *kkk = (dateKEY *) DatumGetPointer(entry->key);
    GBT_NUMKEY_R key;

    /* All cases served by this function are exact */
    *recheck = false;

    key.lower = (GBT_NUMKEY *) &kkk->lower;
    key.upper = (GBT_NUMKEY *) &kkk->upper;

    PG_RETURN_BOOL(
                   gbt_num_consistent(&key, (void *) &query, &strategy, GIST_LEAF(entry), &tinfo)
        );
}

Datum gbt_date_distance ( PG_FUNCTION_ARGS   ) 

Definition at line 173 of file btree_date.c.

References DatumGetPointer, gbt_num_distance(), GIST_LEAF, GISTENTRY::key, dateKEY::lower, GBT_NUMKEY_R::lower, PG_GETARG_DATEADT, PG_GETARG_POINTER, PG_RETURN_FLOAT8, dateKEY::upper, and GBT_NUMKEY_R::upper.

{
    GISTENTRY  *entry = (GISTENTRY *) PG_GETARG_POINTER(0);
    DateADT     query = PG_GETARG_DATEADT(1);

    /* Oid      subtype = PG_GETARG_OID(3); */
    dateKEY    *kkk = (dateKEY *) DatumGetPointer(entry->key);
    GBT_NUMKEY_R key;

    key.lower = (GBT_NUMKEY *) &kkk->lower;
    key.upper = (GBT_NUMKEY *) &kkk->upper;

    PG_RETURN_FLOAT8(
            gbt_num_distance(&key, (void *) &query, GIST_LEAF(entry), &tinfo)
        );
}

Datum gbt_date_penalty ( PG_FUNCTION_ARGS   ) 

Definition at line 203 of file btree_date.c.

References date_mi(), DateADTGetDatum, DatumGetInt32, DatumGetPointer, DirectFunctionCall2, dateKEY::lower, Max, PG_GETARG_POINTER, PG_RETURN_POINTER, and dateKEY::upper.

{
    dateKEY    *origentry = (dateKEY *) DatumGetPointer(((GISTENTRY *) PG_GETARG_POINTER(0))->key);
    dateKEY    *newentry = (dateKEY *) DatumGetPointer(((GISTENTRY *) PG_GETARG_POINTER(1))->key);
    float      *result = (float *) PG_GETARG_POINTER(2);
    int32       diff,
                res;

    diff = DatumGetInt32(DirectFunctionCall2(
                                             date_mi,
                                             DateADTGetDatum(newentry->upper),
                                         DateADTGetDatum(origentry->upper)));

    res = Max(diff, 0);

    diff = DatumGetInt32(DirectFunctionCall2(
                                             date_mi,
                                           DateADTGetDatum(origentry->lower),
                                          DateADTGetDatum(newentry->lower)));

    res += Max(diff, 0);

    *result = 0.0;

    if (res > 0)
    {
        diff = DatumGetInt32(DirectFunctionCall2(
                                                 date_mi,
                                           DateADTGetDatum(origentry->upper),
                                         DateADTGetDatum(origentry->lower)));
        *result += FLT_MIN;
        *result += (float) (res / ((double) (res + diff)));
        *result *= (FLT_MAX / (((GISTENTRY *) PG_GETARG_POINTER(0))->rel->rd_att->natts + 1));
    }

    PG_RETURN_POINTER(result);
}

Datum gbt_date_picksplit ( PG_FUNCTION_ARGS   ) 
Datum gbt_date_same ( PG_FUNCTION_ARGS   ) 

Definition at line 253 of file btree_date.c.

References gbt_num_same(), PG_GETARG_POINTER, and PG_RETURN_POINTER.

{
    dateKEY    *b1 = (dateKEY *) PG_GETARG_POINTER(0);
    dateKEY    *b2 = (dateKEY *) PG_GETARG_POINTER(1);
    bool       *result = (bool *) PG_GETARG_POINTER(2);

    *result = gbt_num_same((void *) b1, (void *) b2, &tinfo);
    PG_RETURN_POINTER(result);
}

Datum gbt_date_union ( PG_FUNCTION_ARGS   ) 

Definition at line 192 of file btree_date.c.

References gbt_num_union(), palloc(), PG_GETARG_POINTER, and PG_RETURN_POINTER.

{
    GistEntryVector *entryvec = (GistEntryVector *) PG_GETARG_POINTER(0);
    void       *out = palloc(sizeof(dateKEY));

    *(int *) PG_GETARG_POINTER(1) = sizeof(dateKEY);
    PG_RETURN_POINTER(gbt_num_union((void *) out, entryvec, &tinfo));
}

static bool gbt_dateeq ( const void *  a,
const void *  b 
) [static]

Definition at line 52 of file btree_date.c.

References date_eq(), DateADTGetDatum, DatumGetBool, and DirectFunctionCall2.

{
    return DatumGetBool(
                        DirectFunctionCall2(date_eq, DateADTGetDatum(*((const DateADT *) a)), DateADTGetDatum(*((const DateADT *) b)))
        );
}

static bool gbt_datege ( const void *  a,
const void *  b 
) [static]

Definition at line 44 of file btree_date.c.

References date_ge(), DateADTGetDatum, DatumGetBool, and DirectFunctionCall2.

{
    return DatumGetBool(
                        DirectFunctionCall2(date_ge, DateADTGetDatum(*((const DateADT *) a)), DateADTGetDatum(*((const DateADT *) b)))
        );
}

static bool gbt_dategt ( const void *  a,
const void *  b 
) [static]

Definition at line 36 of file btree_date.c.

References date_gt(), DateADTGetDatum, DatumGetBool, and DirectFunctionCall2.

{
    return DatumGetBool(
                        DirectFunctionCall2(date_gt, DateADTGetDatum(*((const DateADT *) a)), DateADTGetDatum(*((const DateADT *) b)))
        );
}

static int gbt_datekey_cmp ( const void *  a,
const void *  b 
) [static]

Definition at line 78 of file btree_date.c.

References date_cmp(), DateADTGetDatum, DatumGetInt32, DirectFunctionCall2, dateKEY::lower, and dateKEY::upper.

{
    dateKEY    *ia = (dateKEY *) (((const Nsrt *) a)->t);
    dateKEY    *ib = (dateKEY *) (((const Nsrt *) b)->t);
    int         res;

    res = DatumGetInt32(DirectFunctionCall2(date_cmp, DateADTGetDatum(ia->lower), DateADTGetDatum(ib->lower)));
    if (res == 0)
        return DatumGetInt32(DirectFunctionCall2(date_cmp, DateADTGetDatum(ia->upper), DateADTGetDatum(ib->upper)));

    return res;
}

static bool gbt_datele ( const void *  a,
const void *  b 
) [static]

Definition at line 60 of file btree_date.c.

References date_le(), DateADTGetDatum, DatumGetBool, and DirectFunctionCall2.

{
    return DatumGetBool(
                        DirectFunctionCall2(date_le, DateADTGetDatum(*((const DateADT *) a)), DateADTGetDatum(*((const DateADT *) b)))
        );
}

static bool gbt_datelt ( const void *  a,
const void *  b 
) [static]

Definition at line 68 of file btree_date.c.

References date_lt(), DateADTGetDatum, DatumGetBool, and DirectFunctionCall2.

{
    return DatumGetBool(
                        DirectFunctionCall2(date_lt, DateADTGetDatum(*((const DateADT *) a)), DateADTGetDatum(*((const DateADT *) b)))
        );
}

static float8 gdb_date_dist ( const void *  a,
const void *  b 
) [static]

Definition at line 92 of file btree_date.c.

References Abs, date_mi(), DateADTGetDatum, DatumGetInt32, and DirectFunctionCall2.

{
    /* we assume the difference can't overflow */
    Datum       diff = DirectFunctionCall2(date_mi,
                                     DateADTGetDatum(*((const DateADT *) a)),
                                    DateADTGetDatum(*((const DateADT *) b)));

    return (float8) Abs(DatumGetInt32(diff));
}

PG_FUNCTION_INFO_V1 ( gbt_date_consistent   ) 
PG_FUNCTION_INFO_V1 ( gbt_date_compress   ) 
PG_FUNCTION_INFO_V1 ( gbt_date_union   ) 
PG_FUNCTION_INFO_V1 ( gbt_date_same   ) 
PG_FUNCTION_INFO_V1 ( gbt_date_penalty   ) 
PG_FUNCTION_INFO_V1 ( gbt_date_picksplit   ) 
PG_FUNCTION_INFO_V1 ( gbt_date_distance   ) 
PG_FUNCTION_INFO_V1 ( date_dist   ) 

Variable Documentation

const gbtree_ninfo tinfo [static]
Initial value:

Definition at line 103 of file btree_date.c.