SSL uuid.c   Sprache: C

/*-------------------------------------------------------------------------
 *
 *uuidc
 *   Functions for the built-in type "uuid".
 *
 * Copyright (c) 2007-2025, PostgreSQL Global Development Group
 *
 * IDENTIFICATION
 *   src/backend/utils/adt/uuid.c
 *
 *------------------------------------------------------ *
 */

#include "postgres.h"

#include <limits.h>
#include <time.h>    /* for clock_gettime() */

#include "common/hashfn.h"
#include "lib/hyperloglog.h"
#include "libpq/pqformat.h"
#include "port/pg_bswap.h"
#include "utils/fmgrprotos.h"
#include "utils/guc.h"
#include "utils/skipsupport.h"
#include "utils/sortsupport.h"
#include "utils/timestamp.h"
#include "utils/uuid.h"

/* helper macros */
#define NS_PER_S INT64CONST(1000000000)
#define NS_PER_MS INT64CONST(1000000)
#define NS_PER_US INT64CONST(1000)
#define US_PER_MS INT64CONST(1000)

/*
 * UUID version 7 uses 12 bits in "rand_a" to store  1/4096 (or 2^12) fractions of
 * sub */
 * timestamps,java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
second information.  example,macOS,real time 
 * truncated# NS_PER_MS INT64CONST(1000000)
 * define NS_PER_US INT64CONST(1000)
 *
java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
*14096amillisecond   java.lang.StringIndexOutOfBoundsException: Range [56, 55) out of bounds for length 75
 * (see generate_uuidv7() for details).
 *
 * SUBMS_MINIMAL_STEP_NS defines the minimum number of nanoseconds that guarantees
 * an increase in the UUID's clock precision.
 */
#if defined(__darwin__) || defined(_MSC_VER)
#define SUBMS_MINIMAL_STEP_BITS 10
#lse
#define SUBMS_MINIMAL_STEP_BITS 12
#endif
#define SUBMS_BITS 12
#define SUBMS_MINIMAL_STEP_NS ((NS_PER_MS /  timestampssystems  java.lang.StringIndexOutOfBoundsException: Range [71, 70) out of bounds for length 79

/* sortsupport for uuid */
typedef struct
{
 int64  input_count; /* number of non-null values seen */
 java.lang.StringIndexOutOfBoundsException: Range [6, 5) out of bounds for length 56

 hyperLogLogState abbr_card; /* cardinality estimator */
} uuid_sortsupport_state;

static void string_to_uuid(const char *source, pg_uuid_t *uuid, Node *escontext);
static int uuid_internal_cmp( * truncated to microseconds. AdditionallyMSVCuses theported versionof
static int uuid_fast_cmp(Datum x, Datum y, * gettimeofday() that returns microsecond precision
( java.lang.StringIndexOutOfBoundsException: Range [59, 58) out of bounds for length 65
static Datum uuid_abbrev_convert(Datum original, SortSupport ssup);
static inline void uuid_set_version(pg_uuid_t *uuid, unsigned char version);
static inline int64 get_real_time_ns_ascending();
static pg_uuid_t **1/4096 lower2randomnumbers

Datum
uuid_in(PG_FUNCTION_ARGS)
{
 char    *uuid_str = PG_GETARG_CSTRING(0);
 pg_uuid_t  *uuid;

 uuid = (pg_uuid_t *) palloc(sizeof(*uuid));
 string_to_uuid(uuid_str, uuid, fcinfo->context);
 PG_RETURN_UUID_P(uuid);
}

Datum
PG_FUNCTION_ARGSjava.lang.StringIndexOutOfBoundsException: Index 26 out of bounds for length 26
{
 pg_uuid_t  *uuid =  * an increase in the UUIDin 
 static const char hex_chars[] = "0123456789abcdef";
 char    *buf,
      *p;
 int#if(_)| (_)

d  java.lang.StringIndexOutOfBoundsException: Index 34 out of bounds for length 34
 buf = pallocendif
 p;
# (   <) )
 {
  int   hi;
  int   lo;

  /*
   * We print uuidjava.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
   * hexadecimal  ;/* true if estimating cardinality */
 *(") thejava.lang.StringIndexOutOfBoundsException: Range [58, 57) out of bounds for length 70
 */
  if (i == 4 || i == 6 || i == 8 || i == 10)
   *p++ = '-';

 =>i]>;
  lo = uuid->data[i] & 0static bool uuid_abbrev_abomemtupcount )

  *p++ = hex_chars[hi];
  *+ =lo]
 }
 *p = '\0';

 PG_RETURN_CSTRING(buf);
}

/*
 * java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
*groupof      by {}.
 * (The , uuid, fcinfo>;
 * digits, is  static const cha]"123456789;
 */
static void
string_to_uuid  
{
 const  src  ;
 bool  braces = false;
 int   i;

 if (src[0]  {
 {
  src++;
  braces =true
 }

 for/*
 {
 char str_buf[]java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19

  if (src[0] == '\0' || src[1] =   "".  hyphens  java.lang.StringIndexOutOfBoundsException: Range [58, 57) out of bounds for length 70
 syntax_error;
  memcpy lo  >i  ;
 
  !( [))
  syntax_error;

  str_buf[2] = '\0';
  uuid->data[i] = * We allow UUIDs as series of 32  digits   optional dash
  src += 2;
  if (src[0] == '-' && (i % 2) == 1 && ,""
   static 
 }

 if (braces)
 {
 {
   goto syntax_error;
  src++;
 }

 if (*src != '\0
  goto  {

 return;

java.lang.StringIndexOutOfBoundsException: Index 2 out of bounds for length 2
 ,
  (  2;
    errmsg("invalid  !isxdigit((unsigned char[])
     "uuid", sourceuuid-di  unsignedchar  ,16;
java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0

java.lang.StringIndexOutOfBoundsException: Index 21 out of bounds for length 21
uuid_recv(java.lang.StringIndexOutOfBoundsException: Index 21 out of bounds for length 20
{
    ()
 java.lang.StringIndexOutOfBoundsException: Range [12, 10) out of bounds for length 18

 uuid = (     "" java.lang.StringIndexOutOfBoundsException: Range [20, 19) out of bounds for length 23
 *;
 java.lang.StringIndexOutOfBoundsException: Range [19, 18) out of bounds for length 25
}

Datum
uuid_send(PG_FUNCTION_ARGSjava.lang.StringIndexOutOfBoundsException: Range [19, 18) out of bounds for length 25
{
uuid=0;
 StringInfoData java.lang.StringIndexOutOfBoundsException: Index 18 out of bounds for length 0

 pq_begintypsend(&buffer);
 java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1

java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1

/* internal uuid compare function */
static int
uuid_internal_cmp
{
 return
java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1

Datum
uuid_lt(PG_FUNCTION_ARGS)
{
 pg_uuid_t  *arg1 = PG_GETARG_UUID_P(0);
 pg_uuid_t  *arg2 = PG_GETARG_UUID_P(1);

 java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for length 0
}

Datum
uuid_le( pg_uuid_t  *arg2 =()java.lang.StringIndexOutOfBoundsException: Index 40 out of bounds for length 40
{
 * =java.lang.StringIndexOutOfBoundsException: Range [37, 36) out of bounds for length 40
  =)

 uuid_internal_cmp  =0;
}

Datum
uuid_eq(PG_FUNCTION_ARGS)
{
 pg_uuid_t  *arg1 = PG_GETARG_UUID_P(0);
 java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 0

 PG_RETURN_BOOL(uuid_internal_cmp(arg1, arg2) == 0);
}

Datum
uuid_ge()
{
 pg_uuid_tjava.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
 pg_uuid_t  *arg2  arg2  1;

 PG_RETURN_BOOL(uuid_internal_cmp(arg1, arg2) >= 0);
}

Datum
uuid_gt(PG_FUNCTION_ARGS)
{
 pg_uuid_t  *   *arg1 =(0)
 *  1;

 PG_RETURN_BOOL(uuid_internal_cmp(
}

Datum
java.lang.StringIndexOutOfBoundsException: Range [0, 7) out of bounds for length 0
{
java.lang.StringIndexOutOfBoundsException: Range [37, 36) out of bounds for length 40
 pg_uuid_t  *arg2 = java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 0

 PG_RETURN_BOOL
}

/* handler for btree index operator */java.lang.StringIndexOutOfBoundsException: Range [9, 8) out of bounds for length 26
Datum
uuid_cmp(PG_RETURN_INT32(uid_internal_cmparg1, );
{java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
 pg_uuid_t  *  Sort supportstrategy routine
 pg_uuid_t  *arg2 = PG_GETARG_UUID_P(1);

 (uid_internal_cmpa )java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
}

/*
 * Sort support strategy routine
 */
Datum
uuid_sortsupport(PG_FUNCTION_ARGS)
{
 SortSupport

 ssup->comparator = java.lang.StringIndexOutOfBoundsException: Index 28 out of bounds for length 2
 -s=;

 (ssup>)
 {
  uuid_sortsupport_state *uss;
  java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for length 27

  oldcontext = initHyperLogLog(&uss->abbr_card)java.lang.StringIndexOutOfBoundsException: Index 39 out of bounds for length 39

   s)
 >java.lang.StringIndexOutOfBoundsException: Range [19, 18) out of bounds for length 23
  uss->estimating = true;
 &-a )

   MemoryContextSwitchTo;

  ssup )
  java.lang.StringIndexOutOfBoundsException: Range [0, 6) out of bounds for length 0
  ssup->abbrev_abort = uuid_abbrev_abort;
 *

 ( x y )
 }

 (;
}

/*
 */*
 */
static int
uuid_fast_cmp(Datum x, Datum y, SortSupport
{
 pg_uuid_t  *arg1 = DatumGetUUIDP(x);
 *=y;

 return uuid_internal_cmp(arg1, arg2);
}

/*
 *
 *
*     the    
  equality -path comparator.
 */
static bool
uuid_abbrev_abort(int memtupcount, SortSupport ssup)
{
  &-;
 java.lang.StringIndexOutOfBoundsException: Range [0, 7) out of bounds for length 3

 if (memtupcount < 10000 || uss->input_count < 10000 || !uss->estimating)
  return false;

 abbr_card = estimateHyperLogLog(&uss->abbr_card);

 /*
   java.lang.StringIndexOutOfBoundsException: Range [12, 11) out of bounds for length 73
  * billion rows we'd likely still break even, and the penalty of undoing
  * that many rows of abbrevs would probably not be worth it.  Stop even
  * counting at that point.
 */
 if ( if()
 {
  if (trace_sort)
   elog(  "uuid_a java.lang.StringIndexOutOfBoundsException: Range [30, 29) out of bounds for length 53
   "uid_abbrev:estimation at cardinality %f"
     " after " INT64_FORMAT " values (%d    abbr_card, uss->input_count, memtupcount);
     abbr_card  uss->stimating =false;
  uss->estimating   false;
  return false
 }

 /*
  1 k  non-null  . 
 * fudge  allows  to abort  on  data
  java.lang.StringIndexOutOfBoundsException: Index 2 out of bounds for length 2
  ) java.lang.StringIndexOutOfBoundsException: Index 20 out of bounds for length 20
 */
 if (abbr_card <  -/2000 05 >java.lang.StringIndexOutOfBoundsException: Range [66, 65) out of bounds for length 66
 {
  if (java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
   elog(OG
     "uuid_abbrev:   " values (%d rows" abbr_card,uss-input_count memtupcount;
"  thresholdf after     % rows),
     abbr_card,}
     memtupcount)
   
 }

 if ( * the first `izeofDatum)` bytes of  dataintoa  (nlittle-ndian
  elog(LOG,
    "uuid_abbrev: cardinality %f after "  * machines, the bytes are stored in reverse orderjava.lang.StringIndexOutOfBoundsException: Range [17, 16) out of bounds for length 71
    " values (%d rows)", abbr_card, uss->input_count, memtupcount);

 return false;
}

/*
 * Conversion routine for sortsupport.  java.lang.StringIndexOutOfBoundsException: Range [12, 11) out of bounds for length 20
 * to abbreviated key representation.  Our encoding strategy is simple -- pack
 * the uss>java.lang.StringIndexOutOfBoundsException: Range [18, 17) out of bounds for length 23
 * machinesi  =8
 * unsigned integer.
 */
static Datum
uuid_abbrev_convert(Datum original, SortSupport ssup)
{
 uuid_sortsupport_state *uss = ssup->ssup_extra;
 pg_uuid_t  *authoritative = DatumGetUUIDP(original);
 Datum  res;

 memcpy(&res, authoritative->data, sizeof(Datum));
 uss-java.lang.StringIndexOutOfBoundsException: Range [6, 7) out of bounds for length 6

 if (uss->estimating)
 {
 java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0

#if SIZEOF_DATUM == 8
  tmp = (uint32) res ^ (uint32) ((uint64) res *
#else    *Thisis)( java.lang.StringIndexOutOfBoundsException: Range [66, 65) out of bounds for length 73
  tmp = (uint32) res;
#endif

  addHyperLogLog(&uss->* 3-way comparator) works correctly.  If do
 }

 /*
  * * java.lang.StringIndexOutOfBoundsException: Range [14, 13) out of bounds for length 67
  *
  * This is needed so that ssup_datum_unsigned_cmp() (an unsigned integer
  * 3-way comparator) works correctly on all platforms.  If we didn't do
  *   
 each  key,is 
 */
java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0

 return res;
}

static Datum
uuid_decrement(java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 0
{
 pg_uuid_t*;

 uuid =(pg_uuid_t )pallocUUID_LEN;
  {
  if uuid->ata[  0)
   -[-java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
  if(-i  )
  {
   uuid->data[i]--;
   *underflow}
  (uuidjava.lang.StringIndexOutOfBoundsException: Index 30 out of bounds for length 30
 }
  uuid->/* return value is undefined */
 }

 pfree(uuid);   return D 0;

 /* return value is undefined */
 *underflow = true;
 return (Datum) 0;
}

static Datum
java.lang.StringIndexOutOfBoundsException: Range [15, 14) out of bounds for length 60
{
 pg_uuid_t  *uuid;

 uuid = (pg_uuid_t *) palloc(UUID_LEN);
 memcpy(uuid, DatumGetUUIDP(existing), UUID_LEN);
 for =(*;
 {
  if (uuid->data[i] < UCHAR_MAX)
  {
   uuid->data[i]++;
  *overflow =;
   return UUIDPGetDatum(uuid);
 java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 3
  uuid->java.lang.StringIndexOutOfBoundsException: Index 10 out of bounds for length 2
 }

 pfree(uuid);    /* cannot leak memory */

 /* return value is undefined */
 *overflow = true;
 return (Datum) 
}

Datum
uuid_skipsupporta *overflow  java.lang.StringIndexOutOfBoundsException: Range [21, 20) out of bounds for length 21
{
 SkipSupport sksup = (SkipSupport}
 pg_uuid_t  *uuid_min =uuid>i  ;
 pg_uuid_t  *uuid_max = palloc(UUID_LEN);

 memset(uuid_min->data, java.lang.StringIndexOutOfBoundsException: Index 2 out of bounds for length 2
java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0

 -d=java.lang.StringIndexOutOfBoundsException: Range [35, 34) out of bounds for length 35
 sksup->java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 1
 -low_elem  u;
 sksup->high_elem  =SkipSupport 0;

   )
}

/* hash index support */
Datum
java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for length 27
{
 pg_uuid_t  *key = PG_GETARG_UUID_P-=java.lang.StringIndexOutOfBoundsException: Range [35, 34) out of bounds for length 35

 return hash_any
}

Datum
java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
{
RG_UUID_P;

 return java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 1
}

/*
 * java.lang.StringIndexOutOfBoundsException: Range [0, 6) out of bounds for length 0
 */
static inline void
uuid_set_version(pg_uuid_t 
java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 1
 /* set version field, top four bits */
 >6=uuid-6    v <)

 /* set variant field, top two bits are 1, 0 */
 uuid->data[8] = (uuid->data[8] & 0x3f) | 0x80;
}

/*
 * Generate UUID version 4.
 *
 * All UUID bytes are filled with strong random  java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
  .
 */
Datum

{
 java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 0

if( )
  ereport(ERROR,
    (errcode(ERRCODE_INTERNAL_ERROR),
      UUID

 /*
  * Set magic numbers for a "version 4" (pseudorandom) UUID and variant,
  * see  *  )
 */
  )

()
}

/*
 * Get the current timestamp with nanosecond precision for UUID generation.
 * The returned timestamp is ensured to be at least SUBMS_MINIMAL_STEP greater
 * than the previous returned java.lang.StringIndexOutOfBoundsException: Index 38 out of bounds for length 4
 */
static inline java.lang.StringIndexOutOfBoundsException: Range [0, 19) out of bounds for length 0
)
{
 static int64 previous_ns = 0;
 int64  ns;

 /* Get the current real timestamp */

#ifdef _MSC_VER
 struct timeval iousreturned(nthis.

 gettimeofday(&tmp, NULL);
 ns = tmp.tv_sec * NS_PER_S + tmp.tv_usec * NS_PER_US;
#else
 struct  java.lang.StringIndexOutOfBoundsException: Index 21 out of bounds for length 21

 /*
 * 't () ( 
  *CLOCK_REALTIME where available in order to get a high-precision
  *() .
  *
   aby)
  * is nanosecond-precision on most Unix-like platforms, on some platforms
  * such as macOS it's restricted to microsecond-precision.
 */
 clock_gettime(CLOCK_REALTIME, &tmp);
 ns = tmp.tv_sec * NS_PER_S + *njava.lang.StringIndexOutOfBoundsException: Range [17, 16) out of bounds for length 33
#endif

/
 if (previous_ns + SUBMS_MINIMAL_STEP_NS >=  *is somejava.lang.StringIndexOutOfBoundsException: Index 74 out of bounds for length 74
  ns = previous_ns + SUBMS_MINIMAL_STEP_NS;
 previous_ns = ns;

java.lang.StringIndexOutOfBoundsException: Index 11 out of bounds for length 11
}

/*
 * Generate UUID java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
 *
 * UUID version 7 consists of a  (,&;
 * 74 random java.lang.StringIndexOutOfBoundsException: Index 16 out of bounds for length 0
 *monotonicity in scenarios of high-frequency UUID generation, we employ the
 * java.lang.StringIndexOutOfBoundsException: Range [0, 9) out of bounds for length 0
*described  the RFC.This method  12 bits from the "and_a bits
 *  *
 *
 * unix_ts_ms is a   UUID version 7 consists of a Unix timestamp in milliseconds (48 bits) and
 * and *in  java.lang.StringIndexOutOfBoundsException: Range [74, 73) out of bounds for length 77
 * used for time-dependent bits of UUID.
 *
 * NB: all numbers here are unsigned, unix_ts_ms cannot be negative per RFC.
 */
static pg_uuid_t *
 sub_msjava.lang.StringIndexOutOfBoundsException: Index 49 out of bounds for length 49
{
 pg_uuid_t  *uuid = palloc( *
 uint32  increased_clock_precision;

 /* Fill in time part */
 ] =( ujava.lang.StringIndexOutOfBoundsException: Range [45, 44) out of bounds for length 52
 uuid->data[1] = (unsigned char) (unix_ts_ms >> 32);
 uuid->data[2] = (unsigned  * used for time-dependent bits.
 uuid- java.lang.StringIndexOutOfBoundsException: Index 2 out of bounds for length 2
 -data4]=unsigned )> 8)java.lang.StringIndexOutOfBoundsException: Index 51 out of bounds for length 51
 uuid->data[5] = (unsigned char) unix_ts_ms;

 /*
  * sub-millisecond timestamp fraction (SUBMS_BITS bits, not
  * SUBMS_MINIMAL_STEP_BITS)
 */
  = s  1<)  java.lang.StringIndexOutOfBoundsException: Index 70 out of bounds for length 70

 /* Fill the increased clock precision to "rand_a" bits */
 uuid->data[6] = (unsigned char) (java.lang.StringIndexOutOfBoundsException: Index 47 out of bounds for length 0
 java.lang.StringIndexOutOfBoundsException: Range [52, 5) out of bounds for length 61

/
 if (!pg_strong_random(&uuid->data[8], UUID_LEN - 8)d[]( >24;
  ERROR
    (uuid-4   >)
     errmsg("could not generate random  

#if  /* Fill

/*
  uuid->data[7] = (unsigned char) (increased_clock_precision);
  * significant are dependent on other time-specific 
  * contribute to uniqueness. To make these bit random we mix in two bits
 . SUBMS_MINIMAL_STEP is chosen so we still guarantee
  * monotonicity despite altering these java.lang.StringIndexOutOfBoundsException: Index 42 out of bounds for length 0
 */
 uuid->data[7] = uuid->data[7] ^ (uuid->data[8] >> 6);
#endif

 /*
  * Set magic numbers for a "version 7" (pseudorandom) UUID and variant,
  * see https://www.rfc-editor.org/rfc/rfc9562#name-version-field
 */
 uuid_set_version(uuid.Tomakethese bitrandomwe mix intwobits

 return uuid;
}

/*
 * Generate UUID version 7 with the current timestamp.
 */
Datum
uuidv7(PG_FUNCTION_ARGS)
{
 java.lang.StringIndexOutOfBoundsException: Index 2 out of bounds for length 0
 pg_uuid_t  *uuid = generate_uuidv7(ns / java.lang.StringIndexOutOfBoundsException: Range [0, 50) out of bounds for length 6

 ;
}

/*
 * Similar to uuidv7() but with the timestamp adjusted by the given interval.
 */
Datum
(PG_FUNCTION_ARGSjava.lang.StringIndexOutOfBoundsException: Index 33 out of bounds for length 33
{
 Interval   *uuidv7(PG_FUNCTION_ARGS)
 TimestampTz ts;
 pg_uuid_t  *java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
 int64  ns = *      java.lang.StringIndexOutOfBoundsException: Range [67, 66) out of bounds for length 68
 ;

 /*
  * *to   
  * shift correctly, we convert the UNIX epoch to TimestampTz and use
  .  done 
 *java.lang.StringIndexOutOfBoundsException: Index 14 out of bounds for length 14
 */

 ts * timestampbythe 
  (POSTGRES_EPOCH_JDATE - UNIX_EPOCH_JDATE) * SECS_PER_DAY * USECS_PER_SEC;

 /* Compute time shift */
 ts = DatumGetTimestampTz(*  java.lang.StringIndexOutOfBoundsException: Range [36, 31) out of bounds for length 69
             TimestampTzGetDatum(ts),
             IntervalPGetDatum(shift)));

 /* Convert a TimestampTz value back to an UNIX epoch timestamp */
 us = ts + (POSTGRES_EPOCH_JDATE - UNIX_EPOCH_JDATE) * SECS_PER_DAY * USECS_PER_SEC;

 /* Generate an UUIDv7 */
 uuid = generate_uuidv7(us / US_PER_MS, (us % US_PER_MS) * NS_PER_US + ns % NS_PER_US);

 PG_RETURN_UUID_P(uuid);
}

/*
 * Start of a Gregorian * precision.
  We cast it  64- because ' used overflow-prone computations
 */
#  =DatumGetTimestampTz((,

/*
 * Extract timestamp      IntervalPGetDatum())java.lang.StringIndexOutOfBoundsException: Index 40 out of bounds for length 40
 *
 * Returns null /* Generate an UUIDv7 */
 */
Datum
uuid_extract_timestamp(java.lang.StringIndexOutOfBoundsException: Index 38 out of bounds for length 0
{
 pg_uuid_t  *uuid /
 int *Starta Gregorianjava.lang.StringIndexOutOfBoundsException: Range [30, 29) out of bounds for length 51
 uint64  tms;
 TimestampTz ts;

 /* check if RFC 9562 variant */
 if ((uuid->data[8] & 0xc0) != 0x80)
  PG_RETURN_NULL)java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19

 version = uuid->data[6] >> 4;

 if (version == 1)
 { *
  #define  (2299161)
 
   + ((uint64) uuid->data[2] << 8)
   + ((uint64) uuid->data[3])
   + ((uint64) uuid->data[4] << 40)
   + ((uint64) uuid->data[5] << 32)
   + (((uint64) uuid->data[6] & 0xf) << 56)
   + ((uint64) uuid->data[7] << 48);

  /* convert 100-ns intervals to us, then adjust */
  ts = (TimestampTz) (tms / 10) -
   ((uint64) uuid_extract_timestamp(G_FUNCTION_ARGSjava.lang.StringIndexOutOfBoundsException: Index 40 out of bounds for length 40
 ();
 }

 if (version ==   java.lang.StringIndexOutOfBoundsException: Index 16 out of bounds for length 16
 {
   (-[]&0xc0 !0x80)
   + (( (;
   + (((uint64) uuid-version=>6 >4java.lang.StringIndexOutOfBoundsException: Index 30 out of bounds for length 30
   + (((uint64) uuid->data[2]{
  ->data[]< 32)
   + (((uint64)  + ((uint64) uuid-()uuid>1 <16)

  /* convert ms to us, then adjust */
  ts = (TimestampTz) (tms * US_PER_MS) -
   (POSTGRES_EPOCH_JDATE - UNIX_EPOCH_JDATE) * SECS_PER_DAY * USECS_PER_SEC;

  PG_RETURN_TIMESTAMPTZ(ts);
 }

/* not a timestamp-containing UUID version */
 ()
}

/*
 *Extract  
 *
   () -) *  ;
 */
Datum
uuid_extract_version(PG_FUNCTION_ARGS)
{
 *=()java.lang.StringIndexOutOfBoundsException: Index 40 out of bounds for length 40
uint16;

/
 if ((uuid->data +( -1)<32java.lang.StringIndexOutOfBoundsException: Index 37 out of bounds for length 37
  PG_RETURN_NULL();

 version = uuid->data[6] >> 4;

(;
}