PostgreSQL Source Code git master
Loading...
Searching...
No Matches
varlena.c File Reference
#include "postgres.h"
#include <ctype.h>
#include <limits.h>
#include "access/detoast.h"
#include "access/toast_compression.h"
#include "access/tupmacs.h"
#include "catalog/pg_collation.h"
#include "catalog/pg_type.h"
#include "common/hashfn.h"
#include "common/int.h"
#include "common/unicode_category.h"
#include "common/unicode_norm.h"
#include "common/unicode_version.h"
#include "funcapi.h"
#include "lib/hyperloglog.h"
#include "libpq/pqformat.h"
#include "miscadmin.h"
#include "nodes/execnodes.h"
#include "parser/scansup.h"
#include "port/pg_bswap.h"
#include "regex/regex.h"
#include "utils/builtins.h"
#include "utils/guc.h"
#include "utils/lsyscache.h"
#include "utils/memutils.h"
#include "utils/pg_locale.h"
#include "utils/sortsupport.h"
#include "utils/tuplestore.h"
#include "utils/varlena.h"
#include "levenshtein.c"
Include dependency graph for varlena.c:

Go to the source code of this file.

Data Structures

struct  TextPositionState
 
struct  VarStringSortSupport
 
struct  SplitTextOutputData
 

Macros

#define TEXTBUFLEN   1024
 
#define DatumGetVarStringP(X)   ((VarString *) PG_DETOAST_DATUM(X))
 
#define DatumGetVarStringPP(X)   ((VarString *) PG_DETOAST_DATUM_PACKED(X))
 
#define CmpCall(cmpfunc)
 
#define TEXT_FORMAT_FLAG_MINUS   0x0001 /* is minus flag present? */
 
#define ADVANCE_PARSE_POINTER(ptr, end_ptr)
 
#define LEVENSHTEIN_LESS_EQUAL
 

Typedefs

typedef varlena VarString
 

Functions

static int varstrfastcmp_c (Datum x, Datum y, SortSupport ssup)
 
static int bpcharfastcmp_c (Datum x, Datum y, SortSupport ssup)
 
static int namefastcmp_c (Datum x, Datum y, SortSupport ssup)
 
static int varlenafastcmp_locale (Datum x, Datum y, SortSupport ssup)
 
static int namefastcmp_locale (Datum x, Datum y, SortSupport ssup)
 
static int varstrfastcmp_locale (char *a1p, int len1, char *a2p, int len2, SortSupport ssup)
 
static Datum varstr_abbrev_convert (Datum original, SortSupport ssup)
 
static bool varstr_abbrev_abort (int memtupcount, SortSupport ssup)
 
static int32 text_length (Datum str)
 
static texttext_catenate (text *t1, text *t2)
 
static texttext_substring (Datum str, int32 start, int32 length, bool length_not_specified)
 
static int pg_mbcharcliplen_chars (const char *mbstr, int len, int limit)
 
static texttext_overlay (text *t1, text *t2, int sp, int sl)
 
static int text_position (text *t1, text *t2, Oid collid)
 
static void text_position_setup (text *t1, text *t2, Oid collid, TextPositionState *state)
 
static bool text_position_next (TextPositionState *state)
 
static chartext_position_next_internal (char *start_ptr, TextPositionState *state)
 
static chartext_position_get_match_ptr (TextPositionState *state)
 
static int text_position_get_match_pos (TextPositionState *state)
 
static void text_position_cleanup (TextPositionState *state)
 
static void check_collation_set (Oid collid)
 
static int text_cmp (text *arg1, text *arg2, Oid collid)
 
static void appendStringInfoText (StringInfo str, const text *t)
 
static bool split_text (FunctionCallInfo fcinfo, SplitTextOutputData *tstate)
 
static void split_text_accum_result (SplitTextOutputData *tstate, text *field_value, text *null_string, Oid collation)
 
static textarray_to_text_internal (FunctionCallInfo fcinfo, ArrayType *v, const char *fldsep, const char *null_string)
 
static StringInfo makeStringAggState (FunctionCallInfo fcinfo)
 
static bool text_format_parse_digits (const char **ptr, const char *end_ptr, int *value)
 
static const chartext_format_parse_format (const char *start_ptr, const char *end_ptr, int *argpos, int *widthpos, int *flags, int *width)
 
static void text_format_string_conversion (StringInfo buf, char conversion, FmgrInfo *typOutputInfo, Datum value, bool isNull, int flags, int width)
 
static void text_format_append_string (StringInfo buf, const char *str, int flags, int width)
 
textcstring_to_text (const char *s)
 
textcstring_to_text_with_len (const char *s, int len)
 
chartext_to_cstring (const text *t)
 
void text_to_cstring_buffer (const text *src, char *dst, size_t dst_len)
 
Datum textin (PG_FUNCTION_ARGS)
 
Datum textout (PG_FUNCTION_ARGS)
 
Datum textrecv (PG_FUNCTION_ARGS)
 
Datum textsend (PG_FUNCTION_ARGS)
 
Datum unknownin (PG_FUNCTION_ARGS)
 
Datum unknownout (PG_FUNCTION_ARGS)
 
Datum unknownrecv (PG_FUNCTION_ARGS)
 
Datum unknownsend (PG_FUNCTION_ARGS)
 
Datum textlen (PG_FUNCTION_ARGS)
 
Datum textoctetlen (PG_FUNCTION_ARGS)
 
Datum textcat (PG_FUNCTION_ARGS)
 
static int charlen_to_bytelen (const char *p, int n)
 
Datum text_substr (PG_FUNCTION_ARGS)
 
Datum text_substr_no_len (PG_FUNCTION_ARGS)
 
Datum textoverlay (PG_FUNCTION_ARGS)
 
Datum textoverlay_no_len (PG_FUNCTION_ARGS)
 
Datum textpos (PG_FUNCTION_ARGS)
 
static void text_position_reset (TextPositionState *state)
 
int varstr_cmp (const char *arg1, int len1, const char *arg2, int len2, Oid collid)
 
Datum texteq (PG_FUNCTION_ARGS)
 
Datum textne (PG_FUNCTION_ARGS)
 
Datum text_lt (PG_FUNCTION_ARGS)
 
Datum text_le (PG_FUNCTION_ARGS)
 
Datum text_gt (PG_FUNCTION_ARGS)
 
Datum text_ge (PG_FUNCTION_ARGS)
 
Datum text_starts_with (PG_FUNCTION_ARGS)
 
Datum bttextcmp (PG_FUNCTION_ARGS)
 
Datum bttextsortsupport (PG_FUNCTION_ARGS)
 
void varstr_sortsupport (SortSupport ssup, Oid typid, Oid collid)
 
Datum btvarstrequalimage (PG_FUNCTION_ARGS)
 
Datum text_larger (PG_FUNCTION_ARGS)
 
Datum text_smaller (PG_FUNCTION_ARGS)
 
Datum nameeqtext (PG_FUNCTION_ARGS)
 
Datum texteqname (PG_FUNCTION_ARGS)
 
Datum namenetext (PG_FUNCTION_ARGS)
 
Datum textnename (PG_FUNCTION_ARGS)
 
Datum btnametextcmp (PG_FUNCTION_ARGS)
 
Datum bttextnamecmp (PG_FUNCTION_ARGS)
 
Datum namelttext (PG_FUNCTION_ARGS)
 
Datum nameletext (PG_FUNCTION_ARGS)
 
Datum namegttext (PG_FUNCTION_ARGS)
 
Datum namegetext (PG_FUNCTION_ARGS)
 
Datum textltname (PG_FUNCTION_ARGS)
 
Datum textlename (PG_FUNCTION_ARGS)
 
Datum textgtname (PG_FUNCTION_ARGS)
 
Datum textgename (PG_FUNCTION_ARGS)
 
static int internal_text_pattern_compare (text *arg1, text *arg2)
 
Datum text_pattern_lt (PG_FUNCTION_ARGS)
 
Datum text_pattern_le (PG_FUNCTION_ARGS)
 
Datum text_pattern_ge (PG_FUNCTION_ARGS)
 
Datum text_pattern_gt (PG_FUNCTION_ARGS)
 
Datum bttext_pattern_cmp (PG_FUNCTION_ARGS)
 
Datum bttext_pattern_sortsupport (PG_FUNCTION_ARGS)
 
Datum text_name (PG_FUNCTION_ARGS)
 
Datum name_text (PG_FUNCTION_ARGS)
 
ListtextToQualifiedNameList (text *textval)
 
charscan_quoted_identifier (char **endp, char **nextp)
 
charscan_identifier (char **endp, char **nextp, char separator, bool downcase_unquoted)
 
bool SplitIdentifierString (char *rawstring, char separator, List **namelist)
 
bool SplitDirectoriesString (char *rawstring, char separator, List **namelist)
 
bool SplitGUCList (char *rawstring, char separator, List **namelist)
 
Datum replace_text (PG_FUNCTION_ARGS)
 
static int check_replace_text_has_escape (const text *replace_text)
 
static void appendStringInfoRegexpSubstr (StringInfo str, text *replace_text, regmatch_t *pmatch, char *start_ptr, int data_pos)
 
textreplace_text_regexp (text *src_text, text *pattern_text, text *replace_text, int cflags, Oid collation, int search_start, int n)
 
Datum split_part (PG_FUNCTION_ARGS)
 
static bool text_isequal (text *txt1, text *txt2, Oid collid)
 
Datum text_to_array (PG_FUNCTION_ARGS)
 
Datum text_to_array_null (PG_FUNCTION_ARGS)
 
Datum text_to_table (PG_FUNCTION_ARGS)
 
Datum text_to_table_null (PG_FUNCTION_ARGS)
 
Datum array_to_text (PG_FUNCTION_ARGS)
 
Datum array_to_text_null (PG_FUNCTION_ARGS)
 
static textconvert_to_base (uint64 value, int base)
 
Datum to_bin32 (PG_FUNCTION_ARGS)
 
Datum to_bin64 (PG_FUNCTION_ARGS)
 
Datum to_oct32 (PG_FUNCTION_ARGS)
 
Datum to_oct64 (PG_FUNCTION_ARGS)
 
Datum to_hex32 (PG_FUNCTION_ARGS)
 
Datum to_hex64 (PG_FUNCTION_ARGS)
 
Datum pg_column_size (PG_FUNCTION_ARGS)
 
Datum pg_column_compression (PG_FUNCTION_ARGS)
 
Datum pg_column_toast_chunk_id (PG_FUNCTION_ARGS)
 
Datum string_agg_transfn (PG_FUNCTION_ARGS)
 
Datum string_agg_combine (PG_FUNCTION_ARGS)
 
Datum string_agg_serialize (PG_FUNCTION_ARGS)
 
Datum string_agg_deserialize (PG_FUNCTION_ARGS)
 
Datum string_agg_finalfn (PG_FUNCTION_ARGS)
 
static FmgrInfobuild_concat_foutcache (FunctionCallInfo fcinfo, int argidx)
 
static textconcat_internal (const char *sepstr, int argidx, FunctionCallInfo fcinfo)
 
Datum text_concat (PG_FUNCTION_ARGS)
 
Datum text_concat_ws (PG_FUNCTION_ARGS)
 
Datum text_left (PG_FUNCTION_ARGS)
 
Datum text_right (PG_FUNCTION_ARGS)
 
Datum text_reverse (PG_FUNCTION_ARGS)
 
Datum text_format (PG_FUNCTION_ARGS)
 
Datum text_format_nv (PG_FUNCTION_ARGS)
 
static bool rest_of_char_same (const char *s1, const char *s2, int len)
 
void initClosestMatch (ClosestMatchState *state, const char *source, int max_d)
 
void updateClosestMatch (ClosestMatchState *state, const char *candidate)
 
const chargetClosestMatch (ClosestMatchState *state)
 
static UnicodeNormalizationForm unicode_norm_form_from_string (const char *formstr)
 
Datum unicode_version (PG_FUNCTION_ARGS)
 
Datum icu_unicode_version (PG_FUNCTION_ARGS)
 
Datum unicode_assigned (PG_FUNCTION_ARGS)
 
Datum unicode_normalize_func (PG_FUNCTION_ARGS)
 
Datum unicode_is_normalized (PG_FUNCTION_ARGS)
 
static bool isxdigits_n (const char *instr, size_t n)
 
static unsigned int hexval (unsigned char c)
 
static unsigned int hexval_n (const char *instr, size_t n)
 
Datum unistr (PG_FUNCTION_ARGS)
 

Macro Definition Documentation

◆ ADVANCE_PARSE_POINTER

#define ADVANCE_PARSE_POINTER (   ptr,
  end_ptr 
)
Value:
do { \
if (++(ptr) >= (end_ptr)) \
errmsg("unterminated format() type specifier"), \
errhint("For a single \"%%\" use \"%%%%\"."))); \
} while (0)
int errcode(int sqlerrcode)
Definition elog.c:875
int errhint(const char *fmt,...) pg_attribute_printf(1
#define ERROR
Definition elog.h:40
static char * errmsg
static int fb(int x)

Definition at line 4768 of file varlena.c.

4769 { \
4770 if (++(ptr) >= (end_ptr)) \
4771 ereport(ERROR, \
4773 errmsg("unterminated format() type specifier"), \
4774 errhint("For a single \"%%\" use \"%%%%\"."))); \
4775 } while (0)

◆ CmpCall

#define CmpCall (   cmpfunc)
Value:
Datum DirectFunctionCall2Coll(PGFunction func, Oid collation, Datum arg1, Datum arg2)
Definition fmgr.c:814
#define PG_GETARG_DATUM(n)
Definition fmgr.h:268
#define PG_GET_COLLATION()
Definition fmgr.h:198
static int32 DatumGetInt32(Datum X)
Definition postgres.h:202

Definition at line 2491 of file varlena.c.

◆ DatumGetVarStringP

#define DatumGetVarStringP (   X)    ((VarString *) PG_DETOAST_DATUM(X))

Definition at line 121 of file varlena.c.

◆ DatumGetVarStringPP

#define DatumGetVarStringPP (   X)    ((VarString *) PG_DETOAST_DATUM_PACKED(X))

Definition at line 122 of file varlena.c.

◆ LEVENSHTEIN_LESS_EQUAL

#define LEVENSHTEIN_LESS_EQUAL

Definition at line 5308 of file varlena.c.

◆ TEXT_FORMAT_FLAG_MINUS

#define TEXT_FORMAT_FLAG_MINUS   0x0001 /* is minus flag present? */

Definition at line 4766 of file varlena.c.

◆ TEXTBUFLEN

#define TEXTBUFLEN   1024

Definition at line 119 of file varlena.c.

Typedef Documentation

◆ VarString

Definition at line 47 of file varlena.c.

Function Documentation

◆ appendStringInfoRegexpSubstr()

static void appendStringInfoRegexpSubstr ( StringInfo  str,
text replace_text,
regmatch_t pmatch,
char start_ptr,
int  data_pos 
)
static

Definition at line 3244 of file varlena.c.

3247{
3248 const char *p = VARDATA_ANY(replace_text);
3249 const char *p_end = p + VARSIZE_ANY_EXHDR(replace_text);
3250
3251 while (p < p_end)
3252 {
3253 const char *chunk_start = p;
3254 int so;
3255 int eo;
3256
3257 /* Find next escape char, if any. */
3258 p = memchr(p, '\\', p_end - p);
3259 if (p == NULL)
3260 p = p_end;
3261
3262 /* Copy the text we just scanned over, if any. */
3263 if (p > chunk_start)
3265
3266 /* Done if at end of string, else advance over escape char. */
3267 if (p >= p_end)
3268 break;
3269 p++;
3270
3271 if (p >= p_end)
3272 {
3273 /* Escape at very end of input. Treat same as unexpected char */
3275 break;
3276 }
3277
3278 if (*p >= '1' && *p <= '9')
3279 {
3280 /* Use the back reference of regexp. */
3281 int idx = *p - '0';
3282
3283 so = pmatch[idx].rm_so;
3284 eo = pmatch[idx].rm_eo;
3285 p++;
3286 }
3287 else if (*p == '&')
3288 {
3289 /* Use the entire matched string. */
3290 so = pmatch[0].rm_so;
3291 eo = pmatch[0].rm_eo;
3292 p++;
3293 }
3294 else if (*p == '\\')
3295 {
3296 /* \\ means transfer one \ to output. */
3298 p++;
3299 continue;
3300 }
3301 else
3302 {
3303 /*
3304 * If escape char is not followed by any expected char, just treat
3305 * it as ordinary data to copy. (XXX would it be better to throw
3306 * an error?)
3307 */
3309 continue;
3310 }
3311
3312 if (so >= 0 && eo >= 0)
3313 {
3314 /*
3315 * Copy the text that is back reference of regexp. Note so and eo
3316 * are counted in characters not bytes.
3317 */
3318 char *chunk_start;
3319 int chunk_len;
3320
3321 Assert(so >= data_pos);
3326 }
3327 }
3328}
Datum idx(PG_FUNCTION_ARGS)
Definition _int_op.c:262
#define Assert(condition)
Definition c.h:943
const char * str
void appendBinaryStringInfo(StringInfo str, const void *data, int datalen)
Definition stringinfo.c:281
void appendStringInfoChar(StringInfo str, char ch)
Definition stringinfo.c:242
static Size VARSIZE_ANY_EXHDR(const void *PTR)
Definition varatt.h:472
static char * VARDATA_ANY(const void *PTR)
Definition varatt.h:486
static int charlen_to_bytelen(const char *p, int n)
Definition varlena.c:507
Datum replace_text(PG_FUNCTION_ARGS)
Definition varlena.c:3134

References appendBinaryStringInfo(), appendStringInfoChar(), Assert, charlen_to_bytelen(), fb(), idx(), replace_text(), str, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

Referenced by replace_text_regexp().

◆ appendStringInfoText()

static void appendStringInfoText ( StringInfo  str,
const text t 
)
static

◆ array_to_text()

Datum array_to_text ( PG_FUNCTION_ARGS  )

Definition at line 3907 of file varlena.c.

3908{
3911
3913}
#define PG_GETARG_ARRAYTYPE_P(n)
Definition array.h:263
#define PG_GETARG_TEXT_PP(n)
Definition fmgr.h:310
#define PG_RETURN_TEXT_P(x)
Definition fmgr.h:374
static text * array_to_text_internal(FunctionCallInfo fcinfo, ArrayType *v, const char *fldsep, const char *null_string)
Definition varlena.c:3949
char * text_to_cstring(const text *t)
Definition varlena.c:217

References array_to_text_internal(), fb(), PG_GETARG_ARRAYTYPE_P, PG_GETARG_TEXT_PP, PG_RETURN_TEXT_P, and text_to_cstring().

◆ array_to_text_internal()

static text * array_to_text_internal ( FunctionCallInfo  fcinfo,
ArrayType v,
const char fldsep,
const char null_string 
)
static

Definition at line 3949 of file varlena.c.

3951{
3952 text *result;
3953 int nitems,
3954 *dims,
3955 ndims;
3956 Oid element_type;
3957 int typlen;
3958 bool typbyval;
3959 char typalign;
3960 uint8 typalignby;
3962 bool printed = false;
3963 char *p;
3964 uint8 *bitmap;
3965 int bitmask;
3966 int i;
3968
3969 ndims = ARR_NDIM(v);
3970 dims = ARR_DIMS(v);
3971 nitems = ArrayGetNItems(ndims, dims);
3972
3973 /* if there are no elements, return an empty string */
3974 if (nitems == 0)
3975 return cstring_to_text_with_len("", 0);
3976
3977 element_type = ARR_ELEMTYPE(v);
3979
3980 /*
3981 * We arrange to look up info about element type, including its output
3982 * conversion proc, only once per series of calls, assuming the element
3983 * type doesn't change underneath us.
3984 */
3985 my_extra = (ArrayMetaState *) fcinfo->flinfo->fn_extra;
3986 if (my_extra == NULL)
3987 {
3988 fcinfo->flinfo->fn_extra = MemoryContextAlloc(fcinfo->flinfo->fn_mcxt,
3989 sizeof(ArrayMetaState));
3990 my_extra = (ArrayMetaState *) fcinfo->flinfo->fn_extra;
3991 my_extra->element_type = ~element_type;
3992 }
3993
3994 if (my_extra->element_type != element_type)
3995 {
3996 /*
3997 * Get info about element type, including its output conversion proc
3998 */
3999 get_type_io_data(element_type, IOFunc_output,
4000 &my_extra->typlen, &my_extra->typbyval,
4001 &my_extra->typalign, &my_extra->typdelim,
4002 &my_extra->typioparam, &my_extra->typiofunc);
4003 fmgr_info_cxt(my_extra->typiofunc, &my_extra->proc,
4004 fcinfo->flinfo->fn_mcxt);
4005 my_extra->element_type = element_type;
4006 }
4007 typlen = my_extra->typlen;
4008 typbyval = my_extra->typbyval;
4009 typalign = my_extra->typalign;
4010 typalignby = typalign_to_alignby(typalign);
4011
4012 p = ARR_DATA_PTR(v);
4013 bitmap = ARR_NULLBITMAP(v);
4014 bitmask = 1;
4015
4016 for (i = 0; i < nitems; i++)
4017 {
4019 char *value;
4020
4021 /* Get source element, checking for NULL */
4022 if (bitmap && (*bitmap & bitmask) == 0)
4023 {
4024 /* if null_string is NULL, we just ignore null elements */
4025 if (null_string != NULL)
4026 {
4027 if (printed)
4029 else
4031 printed = true;
4032 }
4033 }
4034 else
4035 {
4036 itemvalue = fetch_att(p, typbyval, typlen);
4037
4039
4040 if (printed)
4041 appendStringInfo(&buf, "%s%s", fldsep, value);
4042 else
4044 printed = true;
4045
4046 p = att_addlength_pointer(p, typlen, p);
4047 p = (char *) att_nominal_alignby(p, typalignby);
4048 }
4049
4050 /* advance bitmap pointer if any */
4051 if (bitmap)
4052 {
4053 bitmask <<= 1;
4054 if (bitmask == 0x100)
4055 {
4056 bitmap++;
4057 bitmask = 1;
4058 }
4059 }
4060 }
4061
4063 pfree(buf.data);
4064
4065 return result;
4066}
#define ARR_NDIM(a)
Definition array.h:290
#define ARR_DATA_PTR(a)
Definition array.h:322
#define ARR_NULLBITMAP(a)
Definition array.h:300
#define ARR_ELEMTYPE(a)
Definition array.h:292
#define ARR_DIMS(a)
Definition array.h:294
int ArrayGetNItems(int ndim, const int *dims)
Definition arrayutils.c:57
uint8_t uint8
Definition c.h:622
uint32 result
void fmgr_info_cxt(Oid functionId, FmgrInfo *finfo, MemoryContext mcxt)
Definition fmgr.c:139
char * OutputFunctionCall(FmgrInfo *flinfo, Datum val)
Definition fmgr.c:1684
#define nitems(x)
Definition indent.h:31
static struct @177 value
int i
Definition isn.c:77
void get_type_io_data(Oid typid, IOFuncSelector which_func, int16 *typlen, bool *typbyval, char *typalign, char *typdelim, Oid *typioparam, Oid *func)
Definition lsyscache.c:2518
@ IOFunc_output
Definition lsyscache.h:37
void * MemoryContextAlloc(MemoryContext context, Size size)
Definition mcxt.c:1232
void pfree(void *pointer)
Definition mcxt.c:1616
static char buf[DEFAULT_XLOG_SEG_SIZE]
char typalign
Definition pg_type.h:178
uint64_t Datum
Definition postgres.h:70
unsigned int Oid
void appendStringInfo(StringInfo str, const char *fmt,...)
Definition stringinfo.c:145
void appendStringInfoString(StringInfo str, const char *s)
Definition stringinfo.c:230
void initStringInfo(StringInfo str)
Definition stringinfo.c:97
void * fn_extra
Definition fmgr.h:64
MemoryContext fn_mcxt
Definition fmgr.h:65
FmgrInfo * flinfo
Definition fmgr.h:87
Definition c.h:776
#define att_nominal_alignby(cur_offset, attalignby)
Definition tupmacs.h:411
#define att_addlength_pointer(cur_offset, attlen, attptr)
Definition tupmacs.h:431
static uint8 typalign_to_alignby(char typalign)
Definition tupmacs.h:302
static Datum fetch_att(const void *T, bool attbyval, int attlen)
Definition tupmacs.h:108
text * cstring_to_text_with_len(const char *s, int len)
Definition varlena.c:196

References appendStringInfo(), appendStringInfoString(), ARR_DATA_PTR, ARR_DIMS, ARR_ELEMTYPE, ARR_NDIM, ARR_NULLBITMAP, ArrayGetNItems(), att_addlength_pointer, att_nominal_alignby, buf, cstring_to_text_with_len(), fb(), fetch_att(), FunctionCallInfoBaseData::flinfo, fmgr_info_cxt(), FmgrInfo::fn_extra, FmgrInfo::fn_mcxt, get_type_io_data(), i, initStringInfo(), IOFunc_output, MemoryContextAlloc(), nitems, OutputFunctionCall(), pfree(), result, typalign, typalign_to_alignby(), and value.

Referenced by array_to_text(), array_to_text_null(), and concat_internal().

◆ array_to_text_null()

Datum array_to_text_null ( PG_FUNCTION_ARGS  )

Definition at line 3923 of file varlena.c.

3924{
3925 ArrayType *v;
3926 char *fldsep;
3927 char *null_string;
3928
3929 /* returns NULL when first or second parameter is NULL */
3930 if (PG_ARGISNULL(0) || PG_ARGISNULL(1))
3932
3933 v = PG_GETARG_ARRAYTYPE_P(0);
3935
3936 /* NULL null string is passed through as a null pointer */
3937 if (!PG_ARGISNULL(2))
3939 else
3940 null_string = NULL;
3941
3943}
#define PG_ARGISNULL(n)
Definition fmgr.h:209
#define PG_RETURN_NULL()
Definition fmgr.h:346

References array_to_text_internal(), fb(), PG_ARGISNULL, PG_GETARG_ARRAYTYPE_P, PG_GETARG_TEXT_PP, PG_RETURN_NULL, PG_RETURN_TEXT_P, and text_to_cstring().

◆ bpcharfastcmp_c()

static int bpcharfastcmp_c ( Datum  x,
Datum  y,
SortSupport  ssup 
)
static

Definition at line 1844 of file varlena.c.

1845{
1848 char *a1p,
1849 *a2p;
1850 int len1,
1851 len2,
1852 result;
1853
1854 a1p = VARDATA_ANY(arg1);
1855 a2p = VARDATA_ANY(arg2);
1856
1859
1860 result = memcmp(a1p, a2p, Min(len1, len2));
1861 if ((result == 0) && (len1 != len2))
1862 result = (len1 < len2) ? -1 : 1;
1863
1864 /* We can't afford to leak memory here. */
1865 if (PointerGetDatum(arg1) != x)
1866 pfree(arg1);
1867 if (PointerGetDatum(arg2) != y)
1868 pfree(arg2);
1869
1870 return result;
1871}
#define Min(x, y)
Definition c.h:1091
#define DatumGetBpCharPP(X)
Definition fmgr.h:294
int y
Definition isn.c:76
int x
Definition isn.c:75
#define PointerGetDatum(X)
Definition postgres.h:354
int bpchartruelen(char *s, int len)
Definition varchar.c:676

References bpchartruelen(), DatumGetBpCharPP, fb(), Min, pfree(), PointerGetDatum, result, VARDATA_ANY(), VARSIZE_ANY_EXHDR(), x, and y.

Referenced by varstr_sortsupport().

◆ btnametextcmp()

Datum btnametextcmp ( PG_FUNCTION_ARGS  )

Definition at line 2460 of file varlena.c.

2461{
2464 int32 result;
2465
2469
2471
2473}
#define NameStr(name)
Definition c.h:835
int32_t int32
Definition c.h:620
#define PG_FREE_IF_COPY(ptr, n)
Definition fmgr.h:260
#define PG_GETARG_NAME(n)
Definition fmgr.h:279
#define PG_RETURN_INT32(x)
Definition fmgr.h:355
Definition c.h:830
int varstr_cmp(const char *arg1, int len1, const char *arg2, int len2, Oid collid)
Definition varlena.c:1355

References fb(), NameStr, PG_FREE_IF_COPY, PG_GET_COLLATION, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_INT32, result, VARDATA_ANY(), VARSIZE_ANY_EXHDR(), and varstr_cmp().

Referenced by namegetext(), namegttext(), nameletext(), and namelttext().

◆ bttext_pattern_cmp()

Datum bttext_pattern_cmp ( PG_FUNCTION_ARGS  )

Definition at line 2643 of file varlena.c.

2644{
2647 int result;
2648
2650
2653
2655}
static int internal_text_pattern_compare(text *arg1, text *arg2)
Definition varlena.c:2557

References fb(), internal_text_pattern_compare(), PG_FREE_IF_COPY, PG_GETARG_TEXT_PP, PG_RETURN_INT32, and result.

◆ bttext_pattern_sortsupport()

Datum bttext_pattern_sortsupport ( PG_FUNCTION_ARGS  )

Definition at line 2659 of file varlena.c.

2660{
2662 MemoryContext oldcontext;
2663
2664 oldcontext = MemoryContextSwitchTo(ssup->ssup_cxt);
2665
2666 /* Use generic string SortSupport, forcing "C" collation */
2668
2669 MemoryContextSwitchTo(oldcontext);
2670
2672}
struct SortSupportData * SortSupport
Definition execnodes.h:61
#define PG_RETURN_VOID()
Definition fmgr.h:350
#define PG_GETARG_POINTER(n)
Definition fmgr.h:277
static MemoryContext MemoryContextSwitchTo(MemoryContext context)
Definition palloc.h:124
MemoryContext ssup_cxt
Definition sortsupport.h:66
void varstr_sortsupport(SortSupport ssup, Oid typid, Oid collid)
Definition varlena.c:1671

References fb(), MemoryContextSwitchTo(), PG_GETARG_POINTER, PG_RETURN_VOID, SortSupportData::ssup_cxt, and varstr_sortsupport().

◆ bttextcmp()

Datum bttextcmp ( PG_FUNCTION_ARGS  )

Definition at line 1631 of file varlena.c.

1632{
1635 int32 result;
1636
1638
1641
1643}
static int text_cmp(text *arg1, text *arg2, Oid collid)
Definition varlena.c:1403

References fb(), PG_FREE_IF_COPY, PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_INT32, result, and text_cmp().

Referenced by gbt_text_ssup_cmp(), and gbt_textcmp().

◆ bttextnamecmp()

◆ bttextsortsupport()

Datum bttextsortsupport ( PG_FUNCTION_ARGS  )

Definition at line 1646 of file varlena.c.

1647{
1649 Oid collid = ssup->ssup_collation;
1650 MemoryContext oldcontext;
1651
1652 oldcontext = MemoryContextSwitchTo(ssup->ssup_cxt);
1653
1654 /* Use generic string SortSupport */
1656
1657 MemoryContextSwitchTo(oldcontext);
1658
1660}
Oid collid

References collid, fb(), MemoryContextSwitchTo(), PG_GETARG_POINTER, PG_RETURN_VOID, SortSupportData::ssup_collation, SortSupportData::ssup_cxt, and varstr_sortsupport().

◆ btvarstrequalimage()

Datum btvarstrequalimage ( PG_FUNCTION_ARGS  )

Definition at line 2315 of file varlena.c.

2316{
2317#ifdef NOT_USED
2318 Oid opcintype = PG_GETARG_OID(0);
2319#endif
2321 pg_locale_t locale;
2322
2324
2326
2328}
#define PG_GETARG_OID(n)
Definition fmgr.h:275
#define PG_RETURN_BOOL(x)
Definition fmgr.h:360
pg_locale_t pg_newlocale_from_collation(Oid collid)
Definition pg_locale.c:1189
static void check_collation_set(Oid collid)
Definition varlena.c:1326

References check_collation_set(), collid, pg_locale_struct::deterministic, PG_GET_COLLATION, PG_GETARG_OID, pg_newlocale_from_collation(), and PG_RETURN_BOOL.

◆ build_concat_foutcache()

static FmgrInfo * build_concat_foutcache ( FunctionCallInfo  fcinfo,
int  argidx 
)
static

Definition at line 4527 of file varlena.c.

4528{
4530 int i;
4531
4532 /* We keep the info in fn_mcxt so it survives across calls */
4534 PG_NARGS() * sizeof(FmgrInfo));
4535
4536 for (i = argidx; i < PG_NARGS(); i++)
4537 {
4538 Oid valtype;
4539 Oid typOutput;
4540 bool typIsVarlena;
4541
4542 valtype = get_fn_expr_argtype(fcinfo->flinfo, i);
4543 if (!OidIsValid(valtype))
4544 elog(ERROR, "could not determine data type of concat() input");
4545
4548 }
4549
4550 fcinfo->flinfo->fn_extra = foutcache;
4551
4552 return foutcache;
4553}
#define OidIsValid(objectId)
Definition c.h:858
#define elog(elevel,...)
Definition elog.h:228
Oid get_fn_expr_argtype(FmgrInfo *flinfo, int argnum)
Definition fmgr.c:1876
#define PG_NARGS()
Definition fmgr.h:203
void getTypeOutputInfo(Oid type, Oid *typOutput, bool *typIsVarlena)
Definition lsyscache.c:3102

References elog, ERROR, fb(), FunctionCallInfoBaseData::flinfo, fmgr_info_cxt(), FmgrInfo::fn_extra, FmgrInfo::fn_mcxt, get_fn_expr_argtype(), getTypeOutputInfo(), i, MemoryContextAlloc(), OidIsValid, and PG_NARGS.

Referenced by concat_internal().

◆ charlen_to_bytelen()

static int charlen_to_bytelen ( const char p,
int  n 
)
static

Definition at line 507 of file varlena.c.

508{
510 {
511 /* Optimization for single-byte encodings */
512 return n;
513 }
514 else
515 {
516 const char *s;
517
518 for (s = p; n > 0; n--)
519 s += pg_mblen_unbounded(s); /* caller verified encoding */
520
521 return s - p;
522 }
523}
int pg_mblen_unbounded(const char *mbstr)
Definition mbutils.c:1137
int pg_database_encoding_max_length(void)
Definition mbutils.c:1672

References pg_database_encoding_max_length(), and pg_mblen_unbounded().

Referenced by appendStringInfoRegexpSubstr(), and replace_text_regexp().

◆ check_collation_set()

static void check_collation_set ( Oid  collid)
static

Definition at line 1326 of file varlena.c.

1327{
1328 if (!OidIsValid(collid))
1329 {
1330 /*
1331 * This typically means that the parser could not resolve a conflict
1332 * of implicit collations, so report it that way.
1333 */
1334 ereport(ERROR,
1336 errmsg("could not determine which collation to use for string comparison"),
1337 errhint("Use the COLLATE clause to set the collation explicitly.")));
1338 }
1339}
#define ereport(elevel,...)
Definition elog.h:152

References collid, ereport, errcode(), errhint(), errmsg, ERROR, fb(), and OidIsValid.

Referenced by btvarstrequalimage(), nameeqtext(), namenetext(), text_position(), text_position_setup(), text_starts_with(), texteq(), texteqname(), textne(), textnename(), varstr_cmp(), and varstr_sortsupport().

◆ check_replace_text_has_escape()

static int check_replace_text_has_escape ( const text replace_text)
static

Definition at line 3211 of file varlena.c.

3212{
3213 int result = 0;
3214 const char *p = VARDATA_ANY(replace_text);
3215 const char *p_end = p + VARSIZE_ANY_EXHDR(replace_text);
3216
3217 while (p < p_end)
3218 {
3219 /* Find next escape char, if any. */
3220 p = memchr(p, '\\', p_end - p);
3221 if (p == NULL)
3222 break;
3223 p++;
3224 /* Note: a backslash at the end doesn't require extra processing. */
3225 if (p < p_end)
3226 {
3227 if (*p >= '1' && *p <= '9')
3228 return 2; /* Found a submatch specifier, so done */
3229 result = 1; /* Found some other sequence, keep looking */
3230 p++;
3231 }
3232 }
3233 return result;
3234}

References fb(), replace_text(), result, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

Referenced by replace_text_regexp().

◆ concat_internal()

static text * concat_internal ( const char sepstr,
int  argidx,
FunctionCallInfo  fcinfo 
)
static

Definition at line 4565 of file varlena.c.

4567{
4568 text *result;
4571 bool first_arg = true;
4572 int i;
4573
4574 /*
4575 * concat(VARIADIC some-array) is essentially equivalent to
4576 * array_to_text(), ie concat the array elements with the given separator.
4577 * So we just pass the case off to that code.
4578 */
4579 if (get_fn_expr_variadic(fcinfo->flinfo))
4580 {
4581 ArrayType *arr;
4582
4583 /* Should have just the one argument */
4584 Assert(argidx == PG_NARGS() - 1);
4585
4586 /* concat(VARIADIC NULL) is defined as NULL */
4587 if (PG_ARGISNULL(argidx))
4588 return NULL;
4589
4590 /*
4591 * Non-null argument had better be an array. We assume that any call
4592 * context that could let get_fn_expr_variadic return true will have
4593 * checked that a VARIADIC-labeled parameter actually is an array. So
4594 * it should be okay to just Assert that it's an array rather than
4595 * doing a full-fledged error check.
4596 */
4598
4599 /* OK, safe to fetch the array value */
4601
4602 /*
4603 * And serialize the array. We tell array_to_text to ignore null
4604 * elements, which matches the behavior of the loop below.
4605 */
4606 return array_to_text_internal(fcinfo, arr, sepstr, NULL);
4607 }
4608
4609 /* Normal case without explicit VARIADIC marker */
4611
4612 /* Get output function info, building it if first time through */
4613 foutcache = (FmgrInfo *) fcinfo->flinfo->fn_extra;
4614 if (foutcache == NULL)
4616
4617 for (i = argidx; i < PG_NARGS(); i++)
4618 {
4619 if (!PG_ARGISNULL(i))
4620 {
4622
4623 /* add separator if appropriate */
4624 if (first_arg)
4625 first_arg = false;
4626 else
4628
4629 /* call the appropriate type output function, append the result */
4632 }
4633 }
4634
4636 pfree(str.data);
4637
4638 return result;
4639}
bool get_fn_expr_variadic(FmgrInfo *flinfo)
Definition fmgr.c:2010
Oid get_base_element_type(Oid typid)
Definition lsyscache.c:3027
static FmgrInfo * build_concat_foutcache(FunctionCallInfo fcinfo, int argidx)
Definition varlena.c:4527

References appendStringInfoString(), array_to_text_internal(), Assert, build_concat_foutcache(), cstring_to_text_with_len(), fb(), FunctionCallInfoBaseData::flinfo, FmgrInfo::fn_extra, get_base_element_type(), get_fn_expr_argtype(), get_fn_expr_variadic(), i, initStringInfo(), OidIsValid, OutputFunctionCall(), pfree(), PG_ARGISNULL, PG_GETARG_ARRAYTYPE_P, PG_GETARG_DATUM, PG_NARGS, result, str, and value.

Referenced by text_concat(), and text_concat_ws().

◆ convert_to_base()

static text * convert_to_base ( uint64  value,
int  base 
)
inlinestatic

Definition at line 4073 of file varlena.c.

4074{
4075 const char *digits = "0123456789abcdef";
4076
4077 /* We size the buffer for to_bin's longest possible return value. */
4078 char buf[sizeof(uint64) * BITS_PER_BYTE];
4079 char *const end = buf + sizeof(buf);
4080 char *ptr = end;
4081
4082 Assert(base > 1);
4083 Assert(base <= 16);
4084
4085 do
4086 {
4087 *--ptr = digits[value % base];
4088 value /= base;
4089 } while (ptr > buf && value);
4090
4091 return cstring_to_text_with_len(ptr, end - ptr);
4092}
uint64_t uint64
Definition c.h:625
int digits
Definition informix.c:691
#define BITS_PER_BYTE

References Assert, BITS_PER_BYTE, buf, cstring_to_text_with_len(), digits, and value.

Referenced by to_bin32(), to_bin64(), to_hex32(), to_hex64(), to_oct32(), and to_oct64().

◆ cstring_to_text()

text * cstring_to_text ( const char s)

Definition at line 184 of file varlena.c.

185{
186 return cstring_to_text_with_len(s, strlen(s));
187}

References cstring_to_text_with_len(), and fb().

Referenced by array_dims(), ASN1_STRING_to_text(), booltext(), brin_minmax_multi_summary_out(), brin_page_type(), build_test_info_result(), build_test_match_result(), casefold(), cidr_abbrev(), convert_charset(), cstring_to_xmltype(), current_query(), cvt_name_text(), datetime_to_char_body(), dblink_build_sql_delete(), dblink_build_sql_insert(), dblink_build_sql_update(), dblink_cancel_query(), dblink_close(), dblink_connect(), dblink_disconnect(), dblink_error_message(), dblink_exec(), dblink_open(), dmetaphone(), dmetaphone_alt(), exec_assign_c_string(), executeDateTimeMethod(), filter_list_to_array(), format_type(), get_command_tag(), get_command_type(), get_scalar(), get_val_in_hash(), hash_page_type(), icu_unicode_version(), inet_abbrev(), initcap(), injection_points_list(), json_in(), json_typeof(), jsonb_get_element(), jsonb_typeof(), JsonbValueAsText(), lower(), md5_bytea(), md5_text(), metaphone(), name_bpchar(), name_text(), network_host(), network_show(), oidvectortypes(), ParameterAclCreate(), ParameterAclLookup(), pg_collation_actual_version(), pg_collation_for(), pg_column_compression(), pg_crypt(), pg_current_logfile(), pg_database_collation_actual_version(), pg_describe_object(), pg_export_snapshot(), pg_get_statisticsobjdef_expressions(), pg_get_wal_replay_pause_state(), pg_parameter_aclmask(), pg_relation_filepath(), pg_size_pretty(), pg_size_pretty_numeric(), pg_stat_get_backend_activity(), pg_stat_get_backend_wait_event(), pg_stat_get_backend_wait_event_type(), pg_stat_get_slru(), pg_stats_ext_mcvlist_items(), pg_tablespace_location(), pg_walfile_name(), pg_xact_status(), pgsql_version(), pgxml_result_to_text(), postgres_fdw_connection(), quote_ident(), quote_ident_cstr(), quote_nullable(), sepgsql_getcon(), sepgsql_mcstrans_in(), sepgsql_mcstrans_out(), set_config_by_name(), show_all_file_settings(), show_config_by_name(), show_config_by_name_missing_ok(), ShowAllGUCConfig(), soundex(), split_part(), ssl_cipher(), ssl_client_dn(), ssl_issuer_dn(), ssl_version(), string_to_text(), test_canonicalize_path(), test_custom_stats_var_report(), test_fdw_connection(), test_lwlock_get_lwlock_identifier(), test_slru_page_read(), test_slru_page_readonly(), text_substring(), textin(), timeofday(), timetz_at_local(), tsquerytree(), unaccent_dict(), unicode_version(), upper(), xml_encode_special_chars(), xml_in(), xml_recv(), and xslt_process().

◆ cstring_to_text_with_len()

text * cstring_to_text_with_len ( const char s,
int  len 
)

Definition at line 196 of file varlena.c.

197{
198 text *result = (text *) palloc(len + VARHDRSZ);
199
201 memcpy(VARDATA(result), s, len);
202
203 return result;
204}
#define VARHDRSZ
Definition c.h:781
memcpy(sums, checksumBaseOffsets, sizeof(checksumBaseOffsets))
void * palloc(Size size)
Definition mcxt.c:1387
const void size_t len
static char * VARDATA(const void *PTR)
Definition varatt.h:305
static void SET_VARSIZE(void *PTR, Size len)
Definition varatt.h:432

References len, memcpy(), palloc(), result, SET_VARSIZE(), VARDATA(), and VARHDRSZ.

Referenced by array_to_json(), array_to_json_pretty(), array_to_text_internal(), brin_minmax_multi_summary_out(), build_regexp_match_result(), build_regexp_split_result(), build_test_match_result(), cash_words(), compute_tsvector_stats(), concat_internal(), convert_to_base(), cstring_to_text(), daitch_mokotoff_coding(), datum_to_json(), do_text_output_multiline(), dotrim(), each_object_field_end(), each_worker_jsonb(), elements_array_element_end(), ExecEvalMergeSupportFunc(), ExecEvalXmlExpr(), executeDateTimeMethod(), executeLikeRegex(), executeStringInternalMethod(), find_or_create_child_node(), fsm_page_contents(), get_array_element_end(), get_array_end(), get_object_end(), get_object_field_end(), get_scalar(), gin_extract_tsquery(), gin_extract_tsvector(), hstore_akeys(), hstore_avals(), hstore_each(), hstore_fetchval(), hstore_skeys(), hstore_slice_to_array(), hstore_subscript_fetch(), hstore_svals(), hstore_to_array_internal(), hstore_to_json(), hstore_to_json_loose(), json_build_array_noargs(), json_build_array_worker(), json_build_object_noargs(), json_build_object_worker(), json_object(), json_object_two_arg(), json_recv(), json_strip_nulls(), jsonb_pretty(), JsonbValueAsText(), leftmostvalue_text(), LogicalOutputWrite(), parse_ident(), pg_gen_salt(), pg_gen_salt_rounds(), pg_get_function_sqlbody(), replace_text(), replace_text_regexp(), row_to_json(), row_to_json_pretty(), serialize_deflist(), split_part(), split_text(), ssl_extension_info(), string_agg_finalfn(), stringinfo_to_xmltype(), text_format(), text_left(), text_right(), textrecv(), transform_json_string_values(), tsquerytree(), tsvector_to_array(), tsvector_unnest(), unistr(), varchar(), varchar_input(), xmltext(), xmltotext_with_options(), and xslt_process().

◆ getClosestMatch()

const char * getClosestMatch ( ClosestMatchState state)

Definition at line 5386 of file varlena.c.

5387{
5388 Assert(state);
5389
5390 return state->match;
5391}

References Assert.

Referenced by dblink_fdw_validator(), file_fdw_validator(), postgres_fdw_validator(), and postgresql_fdw_validator().

◆ hexval()

static unsigned int hexval ( unsigned char  c)
static

Definition at line 5616 of file varlena.c.

5617{
5618 if (c >= '0' && c <= '9')
5619 return c - '0';
5620 if (c >= 'a' && c <= 'f')
5621 return c - 'a' + 0xA;
5622 if (c >= 'A' && c <= 'F')
5623 return c - 'A' + 0xA;
5624 elog(ERROR, "invalid hexadecimal digit");
5625 return 0; /* not reached */
5626}
char * c

References elog, and ERROR.

Referenced by hexval_n().

◆ hexval_n()

static unsigned int hexval_n ( const char instr,
size_t  n 
)
static

Definition at line 5632 of file varlena.c.

5633{
5634 unsigned int result = 0;
5635
5636 for (size_t i = 0; i < n; i++)
5637 result += hexval(instr[i]) << (4 * (n - i - 1));
5638
5639 return result;
5640}
static unsigned int hexval(unsigned char c)
Definition varlena.c:5616

References hexval(), i, and result.

Referenced by unistr().

◆ icu_unicode_version()

Datum icu_unicode_version ( PG_FUNCTION_ARGS  )

Definition at line 5445 of file varlena.c.

5446{
5447 const char *version = pg_icu_unicode_version();
5448
5449 if (version)
5451 else
5453}
const char * pg_icu_unicode_version(void)
Definition pg_locale.c:1653
text * cstring_to_text(const char *s)
Definition varlena.c:184

References cstring_to_text(), pg_icu_unicode_version(), PG_RETURN_NULL, and PG_RETURN_TEXT_P.

Referenced by main().

◆ initClosestMatch()

void initClosestMatch ( ClosestMatchState state,
const char source,
int  max_d 
)

Definition at line 5331 of file varlena.c.

5332{
5333 Assert(state);
5334 Assert(max_d >= 0);
5335
5336 state->source = source;
5337 state->min_d = -1;
5338 state->max_d = max_d;
5339 state->match = NULL;
5340}
static rewind_source * source
Definition pg_rewind.c:89

References Assert, fb(), and source.

Referenced by dblink_fdw_validator(), file_fdw_validator(), postgres_fdw_validator(), and postgresql_fdw_validator().

◆ internal_text_pattern_compare()

static int internal_text_pattern_compare ( text arg1,
text arg2 
)
static

Definition at line 2557 of file varlena.c.

2558{
2559 int result;
2560 int len1,
2561 len2;
2562
2563 len1 = VARSIZE_ANY_EXHDR(arg1);
2564 len2 = VARSIZE_ANY_EXHDR(arg2);
2565
2566 result = memcmp(VARDATA_ANY(arg1), VARDATA_ANY(arg2), Min(len1, len2));
2567 if (result != 0)
2568 return result;
2569 else if (len1 < len2)
2570 return -1;
2571 else if (len1 > len2)
2572 return 1;
2573 else
2574 return 0;
2575}

References fb(), Min, result, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

Referenced by bttext_pattern_cmp(), text_pattern_ge(), text_pattern_gt(), text_pattern_le(), and text_pattern_lt().

◆ isxdigits_n()

static bool isxdigits_n ( const char instr,
size_t  n 
)
static

Definition at line 5606 of file varlena.c.

5607{
5608 for (size_t i = 0; i < n; i++)
5609 if (!isxdigit((unsigned char) instr[i]))
5610 return false;
5611
5612 return true;
5613}

References fb(), and i.

Referenced by unistr().

◆ makeStringAggState()

static StringInfo makeStringAggState ( FunctionCallInfo  fcinfo)
static

Definition at line 4305 of file varlena.c.

4306{
4308 MemoryContext aggcontext;
4309 MemoryContext oldcontext;
4310
4311 if (!AggCheckCallContext(fcinfo, &aggcontext))
4312 {
4313 /* cannot be called directly because of internal-type argument */
4314 elog(ERROR, "string_agg_transfn called in non-aggregate context");
4315 }
4316
4317 /*
4318 * Create state in aggregate context. It'll stay there across subsequent
4319 * calls.
4320 */
4321 oldcontext = MemoryContextSwitchTo(aggcontext);
4323 MemoryContextSwitchTo(oldcontext);
4324
4325 return state;
4326}
int AggCheckCallContext(FunctionCallInfo fcinfo, MemoryContext *aggcontext)
Definition nodeAgg.c:4609
StringInfo makeStringInfo(void)
Definition stringinfo.c:72

References AggCheckCallContext(), elog, ERROR, makeStringInfo(), and MemoryContextSwitchTo().

Referenced by string_agg_combine(), string_agg_deserialize(), and string_agg_transfn().

◆ name_text()

Datum name_text ( PG_FUNCTION_ARGS  )

Definition at line 2702 of file varlena.c.

2703{
2704 Name s = PG_GETARG_NAME(0);
2705
2707}

References cstring_to_text(), NameStr, PG_GETARG_NAME, and PG_RETURN_TEXT_P.

Referenced by nameiclike(), and nameicnlike().

◆ nameeqtext()

Datum nameeqtext ( PG_FUNCTION_ARGS  )

Definition at line 2360 of file varlena.c.

2361{
2364 size_t len1 = strlen(NameStr(*arg1));
2365 size_t len2 = VARSIZE_ANY_EXHDR(arg2);
2367 bool result;
2368
2370
2371 if (collid == C_COLLATION_OID)
2372 result = (len1 == len2 &&
2373 memcmp(NameStr(*arg1), VARDATA_ANY(arg2), len1) == 0);
2374 else
2375 result = (varstr_cmp(NameStr(*arg1), len1,
2376 VARDATA_ANY(arg2), len2,
2377 collid) == 0);
2378
2380
2382}

References check_collation_set(), collid, fb(), NameStr, PG_FREE_IF_COPY, PG_GET_COLLATION, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, VARDATA_ANY(), VARSIZE_ANY_EXHDR(), and varstr_cmp().

◆ namefastcmp_c()

static int namefastcmp_c ( Datum  x,
Datum  y,
SortSupport  ssup 
)
static

Definition at line 1877 of file varlena.c.

1878{
1881
1883}
#define NAMEDATALEN
static Name DatumGetName(Datum X)
Definition postgres.h:393

References DatumGetName(), fb(), NAMEDATALEN, NameStr, x, and y.

Referenced by varstr_sortsupport().

◆ namefastcmp_locale()

static int namefastcmp_locale ( Datum  x,
Datum  y,
SortSupport  ssup 
)
static

Definition at line 1920 of file varlena.c.

1921{
1924
1927 ssup);
1928}
static int varstrfastcmp_locale(char *a1p, int len1, char *a2p, int len2, SortSupport ssup)
Definition varlena.c:1934

References DatumGetName(), fb(), NameStr, varstrfastcmp_locale(), x, and y.

Referenced by varstr_sortsupport().

◆ namegetext()

Datum namegetext ( PG_FUNCTION_ARGS  )

Definition at line 2516 of file varlena.c.

2517{
2519}
#define CmpCall(cmpfunc)
Definition varlena.c:2491
Datum btnametextcmp(PG_FUNCTION_ARGS)
Definition varlena.c:2460

References btnametextcmp(), CmpCall, and PG_RETURN_BOOL.

◆ namegttext()

Datum namegttext ( PG_FUNCTION_ARGS  )

Definition at line 2510 of file varlena.c.

2511{
2513}

References btnametextcmp(), CmpCall, and PG_RETURN_BOOL.

◆ nameletext()

Datum nameletext ( PG_FUNCTION_ARGS  )

Definition at line 2504 of file varlena.c.

2505{
2507}

References btnametextcmp(), CmpCall, and PG_RETURN_BOOL.

◆ namelttext()

Datum namelttext ( PG_FUNCTION_ARGS  )

Definition at line 2498 of file varlena.c.

2499{
2501}

References btnametextcmp(), CmpCall, and PG_RETURN_BOOL.

◆ namenetext()

Datum namenetext ( PG_FUNCTION_ARGS  )

Definition at line 2410 of file varlena.c.

2411{
2414 size_t len1 = strlen(NameStr(*arg1));
2415 size_t len2 = VARSIZE_ANY_EXHDR(arg2);
2417 bool result;
2418
2420
2421 if (collid == C_COLLATION_OID)
2422 result = !(len1 == len2 &&
2423 memcmp(NameStr(*arg1), VARDATA_ANY(arg2), len1) == 0);
2424 else
2425 result = !(varstr_cmp(NameStr(*arg1), len1,
2426 VARDATA_ANY(arg2), len2,
2427 collid) == 0);
2428
2430
2432}

References check_collation_set(), collid, fb(), NameStr, PG_FREE_IF_COPY, PG_GET_COLLATION, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, VARDATA_ANY(), VARSIZE_ANY_EXHDR(), and varstr_cmp().

◆ pg_column_compression()

Datum pg_column_compression ( PG_FUNCTION_ARGS  )

Definition at line 4204 of file varlena.c.

4205{
4206 int typlen;
4207 char *result;
4209
4210 /* On first call, get the input type's typlen, and save at *fn_extra */
4211 if (fcinfo->flinfo->fn_extra == NULL)
4212 {
4213 /* Lookup the datatype of the supplied argument */
4214 Oid argtypeid = get_fn_expr_argtype(fcinfo->flinfo, 0);
4215
4216 typlen = get_typlen(argtypeid);
4217 if (typlen == 0) /* should not happen */
4218 elog(ERROR, "cache lookup failed for type %u", argtypeid);
4219
4220 fcinfo->flinfo->fn_extra = MemoryContextAlloc(fcinfo->flinfo->fn_mcxt,
4221 sizeof(int));
4222 *((int *) fcinfo->flinfo->fn_extra) = typlen;
4223 }
4224 else
4225 typlen = *((int *) fcinfo->flinfo->fn_extra);
4226
4227 if (typlen != -1)
4229
4230 /* get the compression method id stored in the compressed varlena */
4235
4236 /* convert compression method id to compression method name */
4237 switch (cmid)
4238 {
4240 result = "pglz";
4241 break;
4243 result = "lz4";
4244 break;
4245 default:
4246 elog(ERROR, "invalid compression method id %d", cmid);
4247 }
4248
4250}
int16 get_typlen(Oid typid)
Definition lsyscache.c:2390
static Pointer DatumGetPointer(Datum X)
Definition postgres.h:332
ToastCompressionId toast_get_compression_id(varlena *attr)
ToastCompressionId
@ TOAST_INVALID_COMPRESSION_ID
@ TOAST_LZ4_COMPRESSION_ID
@ TOAST_PGLZ_COMPRESSION_ID

References cstring_to_text(), DatumGetPointer(), elog, ERROR, fb(), get_fn_expr_argtype(), get_typlen(), MemoryContextAlloc(), PG_GETARG_DATUM, PG_RETURN_NULL, PG_RETURN_TEXT_P, result, toast_get_compression_id(), TOAST_INVALID_COMPRESSION_ID, TOAST_LZ4_COMPRESSION_ID, and TOAST_PGLZ_COMPRESSION_ID.

◆ pg_column_size()

Datum pg_column_size ( PG_FUNCTION_ARGS  )

Definition at line 4157 of file varlena.c.

4158{
4160 int32 result;
4161 int typlen;
4162
4163 /* On first call, get the input type's typlen, and save at *fn_extra */
4164 if (fcinfo->flinfo->fn_extra == NULL)
4165 {
4166 /* Lookup the datatype of the supplied argument */
4167 Oid argtypeid = get_fn_expr_argtype(fcinfo->flinfo, 0);
4168
4169 typlen = get_typlen(argtypeid);
4170 if (typlen == 0) /* should not happen */
4171 elog(ERROR, "cache lookup failed for type %u", argtypeid);
4172
4173 fcinfo->flinfo->fn_extra = MemoryContextAlloc(fcinfo->flinfo->fn_mcxt,
4174 sizeof(int));
4175 *((int *) fcinfo->flinfo->fn_extra) = typlen;
4176 }
4177 else
4178 typlen = *((int *) fcinfo->flinfo->fn_extra);
4179
4180 if (typlen == -1)
4181 {
4182 /* varlena type, possibly toasted */
4184 }
4185 else if (typlen == -2)
4186 {
4187 /* cstring */
4189 }
4190 else
4191 {
4192 /* ordinary fixed-width type */
4193 result = typlen;
4194 }
4195
4197}
Size toast_datum_size(Datum value)
Definition detoast.c:601
static char * DatumGetCString(Datum X)
Definition postgres.h:365

References DatumGetCString(), elog, ERROR, fb(), get_fn_expr_argtype(), get_typlen(), MemoryContextAlloc(), PG_GETARG_DATUM, PG_RETURN_INT32, result, toast_datum_size(), and value.

◆ pg_column_toast_chunk_id()

Datum pg_column_toast_chunk_id ( PG_FUNCTION_ARGS  )

Definition at line 4257 of file varlena.c.

4258{
4259 int typlen;
4260 varlena *attr;
4261 varatt_external toast_pointer;
4262
4263 /* On first call, get the input type's typlen, and save at *fn_extra */
4264 if (fcinfo->flinfo->fn_extra == NULL)
4265 {
4266 /* Lookup the datatype of the supplied argument */
4267 Oid argtypeid = get_fn_expr_argtype(fcinfo->flinfo, 0);
4268
4269 typlen = get_typlen(argtypeid);
4270 if (typlen == 0) /* should not happen */
4271 elog(ERROR, "cache lookup failed for type %u", argtypeid);
4272
4273 fcinfo->flinfo->fn_extra = MemoryContextAlloc(fcinfo->flinfo->fn_mcxt,
4274 sizeof(int));
4275 *((int *) fcinfo->flinfo->fn_extra) = typlen;
4276 }
4277 else
4278 typlen = *((int *) fcinfo->flinfo->fn_extra);
4279
4280 if (typlen != -1)
4282
4284
4285 if (!VARATT_IS_EXTERNAL_ONDISK(attr))
4287
4288 VARATT_EXTERNAL_GET_POINTER(toast_pointer, attr);
4289
4290 PG_RETURN_OID(toast_pointer.va_valueid);
4291}
#define VARATT_EXTERNAL_GET_POINTER(toast_pointer, attr)
Definition detoast.h:22
#define PG_RETURN_OID(x)
Definition fmgr.h:361
static bool VARATT_IS_EXTERNAL_ONDISK(const void *PTR)
Definition varatt.h:361

References DatumGetPointer(), elog, ERROR, fb(), get_fn_expr_argtype(), get_typlen(), MemoryContextAlloc(), PG_GETARG_DATUM, PG_RETURN_NULL, PG_RETURN_OID, varatt_external::va_valueid, VARATT_EXTERNAL_GET_POINTER, and VARATT_IS_EXTERNAL_ONDISK().

◆ pg_mbcharcliplen_chars()

static int pg_mbcharcliplen_chars ( const char mbstr,
int  len,
int  limit 
)
static

Definition at line 804 of file varlena.c.

805{
806 int nch = 0;
807 int l;
808
809 Assert(len > 0);
810 Assert(limit > 0);
812
813 while (len > 0 && *mbstr)
814 {
816 nch++;
817 if (nch == limit)
818 break;
819 len -= l;
820 mbstr += l;
821 }
822 return nch;
823}
int pg_mblen_with_len(const char *mbstr, int limit)
Definition mbutils.c:1108

References Assert, fb(), len, pg_database_encoding_max_length(), and pg_mblen_with_len().

Referenced by text_substring().

◆ replace_text()

Datum replace_text ( PG_FUNCTION_ARGS  )

Definition at line 3134 of file varlena.c.

3135{
3139 int src_text_len;
3142 text *ret_text;
3143 int chunk_len;
3144 char *curr_ptr;
3145 char *start_ptr;
3147 bool found;
3148
3151
3152 /* Return unmodified source string if empty source or pattern */
3153 if (src_text_len < 1 || from_sub_text_len < 1)
3154 {
3156 }
3157
3159
3160 found = text_position_next(&state);
3161
3162 /* When the from_sub_text is not found, there is nothing to do. */
3163 if (!found)
3164 {
3167 }
3170
3172
3173 do
3174 {
3176
3177 /* copy the data skipped over by last text_position_next() */
3180
3182
3183 start_ptr = curr_ptr + state.last_match_len;
3184
3185 found = text_position_next(&state);
3186 if (found)
3188 }
3189 while (found);
3190
3191 /* copy trailing data */
3194
3196
3198 pfree(str.data);
3199
3201}
#define CHECK_FOR_INTERRUPTS()
Definition miscadmin.h:125
static Size VARSIZE_ANY(const void *PTR)
Definition varatt.h:460
static void text_position_setup(text *t1, text *t2, Oid collid, TextPositionState *state)
Definition varlena.c:962
static void text_position_cleanup(TextPositionState *state)
Definition varlena.c:1319
static void appendStringInfoText(StringInfo str, const text *t)
Definition varlena.c:3120
static char * text_position_get_match_ptr(TextPositionState *state)
Definition varlena.c:1284
static bool text_position_next(TextPositionState *state)
Definition varlena.c:1083

References appendBinaryStringInfo(), appendStringInfoText(), CHECK_FOR_INTERRUPTS, cstring_to_text_with_len(), fb(), initStringInfo(), pfree(), PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_TEXT_P, str, text_position_cleanup(), text_position_get_match_ptr(), text_position_next(), text_position_setup(), VARDATA_ANY(), VARSIZE_ANY(), and VARSIZE_ANY_EXHDR().

Referenced by appendStringInfoRegexpSubstr(), check_replace_text_has_escape(), execute_extension_script(), executeStringInternalMethod(), and replace_text_regexp().

◆ replace_text_regexp()

text * replace_text_regexp ( text src_text,
text pattern_text,
text replace_text,
int  cflags,
Oid  collation,
int  search_start,
int  n 
)

Definition at line 3344 of file varlena.c.

3348{
3349 text *ret_text;
3350 regex_t *re;
3352 int nmatches = 0;
3354 regmatch_t pmatch[10]; /* main match, plus \1 to \9 */
3355 int nmatch = lengthof(pmatch);
3356 pg_wchar *data;
3357 size_t data_len;
3358 int data_pos;
3359 char *start_ptr;
3360 int escape_status;
3361
3363
3364 /* Convert data string to wide characters. */
3365 data = (pg_wchar *) palloc((src_text_len + 1) * sizeof(pg_wchar));
3367
3368 /* Check whether replace_text has escapes, especially regexp submatches. */
3370
3371 /* If no regexp submatches, we can use REG_NOSUB. */
3372 if (escape_status < 2)
3373 {
3374 cflags |= REG_NOSUB;
3375 /* Also tell pg_regexec we only want the whole-match location. */
3376 nmatch = 1;
3377 }
3378
3379 /* Prepare the regexp. */
3380 re = RE_compile_and_cache(pattern_text, cflags, collation);
3381
3382 /* start_ptr points to the data_pos'th character of src_text */
3383 start_ptr = (char *) VARDATA_ANY(src_text);
3384 data_pos = 0;
3385
3386 while (search_start <= data_len)
3387 {
3388 int regexec_result;
3389
3391
3393 data,
3394 data_len,
3395 search_start,
3396 NULL, /* no details */
3397 nmatch,
3398 pmatch,
3399 0);
3400
3402 break;
3403
3404 if (regexec_result != REG_OKAY)
3405 {
3406 char errMsg[100];
3407
3408 pg_regerror(regexec_result, re, errMsg, sizeof(errMsg));
3409 ereport(ERROR,
3411 errmsg("regular expression failed: %s", errMsg)));
3412 }
3413
3414 /*
3415 * Count matches, and decide whether to replace this match.
3416 */
3417 nmatches++;
3418 if (n > 0 && nmatches != n)
3419 {
3420 /*
3421 * No, so advance search_start, but not start_ptr/data_pos. (Thus,
3422 * we treat the matched text as if it weren't matched, and copy it
3423 * to the output later.)
3424 */
3425 search_start = pmatch[0].rm_eo;
3426 if (pmatch[0].rm_so == pmatch[0].rm_eo)
3427 search_start++;
3428 continue;
3429 }
3430
3431 /*
3432 * Copy the text to the left of the match position. Note we are given
3433 * character not byte indexes.
3434 */
3435 if (pmatch[0].rm_so - data_pos > 0)
3436 {
3437 int chunk_len;
3438
3440 pmatch[0].rm_so - data_pos);
3442
3443 /*
3444 * Advance start_ptr over that text, to avoid multiple rescans of
3445 * it if the replace_text contains multiple back-references.
3446 */
3448 data_pos = pmatch[0].rm_so;
3449 }
3450
3451 /*
3452 * Copy the replace_text, processing escapes if any are present.
3453 */
3454 if (escape_status > 0)
3457 else
3459
3460 /* Advance start_ptr and data_pos over the matched text. */
3462 pmatch[0].rm_eo - data_pos);
3463 data_pos = pmatch[0].rm_eo;
3464
3465 /*
3466 * If we only want to replace one occurrence, we're done.
3467 */
3468 if (n > 0)
3469 break;
3470
3471 /*
3472 * Advance search position. Normally we start the next search at the
3473 * end of the previous match; but if the match was of zero length, we
3474 * have to advance by one character, or we'd just find the same match
3475 * again.
3476 */
3477 search_start = data_pos;
3478 if (pmatch[0].rm_so == pmatch[0].rm_eo)
3479 search_start++;
3480 }
3481
3482 /*
3483 * Copy the text to the right of the last match.
3484 */
3485 if (data_pos < data_len)
3486 {
3487 int chunk_len;
3488
3491 }
3492
3494 pfree(buf.data);
3495 pfree(data);
3496
3497 return ret_text;
3498}
#define lengthof(array)
Definition c.h:873
unsigned int pg_wchar
Definition mbprint.c:31
int pg_mb2wchar_with_len(const char *from, pg_wchar *to, int len)
Definition mbutils.c:997
const void * data
size_t pg_regerror(int errcode, const regex_t *preg, char *errbuf, size_t errbuf_size)
Definition regerror.c:60
#define REG_NOMATCH
Definition regex.h:216
#define regmatch_t
Definition regex.h:246
#define REG_OKAY
Definition regex.h:215
#define REG_NOSUB
Definition regex.h:185
#define regex_t
Definition regex.h:245
int pg_regexec(regex_t *re, const chr *string, size_t len, size_t search_start, rm_detail_t *details, size_t nmatch, regmatch_t pmatch[], int flags)
Definition regexec.c:185
regex_t * RE_compile_and_cache(text *text_re, int cflags, Oid collation)
Definition regexp.c:141
static int check_replace_text_has_escape(const text *replace_text)
Definition varlena.c:3211
static void appendStringInfoRegexpSubstr(StringInfo str, text *replace_text, regmatch_t *pmatch, char *start_ptr, int data_pos)
Definition varlena.c:3244

References appendBinaryStringInfo(), appendStringInfoRegexpSubstr(), appendStringInfoText(), buf, charlen_to_bytelen(), CHECK_FOR_INTERRUPTS, check_replace_text_has_escape(), cstring_to_text_with_len(), data, ereport, errcode(), errmsg, ERROR, fb(), initStringInfo(), lengthof, palloc(), pfree(), pg_mb2wchar_with_len(), pg_regerror(), pg_regexec(), RE_compile_and_cache(), REG_NOMATCH, REG_NOSUB, REG_OKAY, regex_t, regmatch_t, replace_text(), VARDATA_ANY(), VARSIZE_ANY(), and VARSIZE_ANY_EXHDR().

Referenced by textregexreplace(), textregexreplace_extended(), and textregexreplace_noopt().

◆ rest_of_char_same()

static bool rest_of_char_same ( const char s1,
const char s2,
int  len 
)
inlinestatic

Definition at line 5295 of file varlena.c.

5296{
5297 while (len > 0)
5298 {
5299 len--;
5300 if (s1[len] != s2[len])
5301 return false;
5302 }
5303 return true;
5304}
char * s1
char * s2

References len, s1, and s2.

Referenced by varstr_levenshtein().

◆ scan_identifier()

char * scan_identifier ( char **  endp,
char **  nextp,
char  separator,
bool  downcase_unquoted 
)

Definition at line 2802 of file varlena.c.

2803{
2804 char *token;
2805
2806 if (**nextp == '"')
2808
2809 /* Unquoted identifier --- extends to separator or whitespace */
2810 token = *nextp;
2811
2812 while (**nextp && **nextp != separator && !scanner_isspace(**nextp))
2813 (*nextp)++;
2814
2815 if (*nextp == token)
2816 return NULL; /* empty token */
2817
2818 *endp = *nextp;
2819
2821 {
2822 /*
2823 * Downcase the identifier, using same code as main lexer does.
2824 *
2825 * XXX because we want to overwrite the input in-place, we cannot
2826 * support a downcasing transformation that increases the string
2827 * length. This is not a problem given the current implementation of
2828 * downcase_truncate_identifier, but we'll probably have to do
2829 * something about this someday.
2830 */
2831 int len = *endp - token;
2833
2835 strncpy(token, downname, len); /* strncpy is required here */
2836 pfree(downname);
2837 }
2838
2839 return token;
2840}
#define token
char * downcase_truncate_identifier(const char *ident, int len, bool warn)
Definition scansup.c:38
bool scanner_isspace(char ch)
Definition scansup.c:105
char * scan_quoted_identifier(char **endp, char **nextp)
Definition varlena.c:2767

References Assert, downcase_truncate_identifier(), fb(), len, pfree(), scan_quoted_identifier(), scanner_isspace(), and token.

Referenced by auto_explain_split_options(), SplitGUCList(), and SplitIdentifierString().

◆ scan_quoted_identifier()

char * scan_quoted_identifier ( char **  endp,
char **  nextp 
)

Definition at line 2767 of file varlena.c.

2768{
2769 char *token = *nextp + 1;
2770
2771 for (;;)
2772 {
2773 *endp = strchr(*nextp + 1, '"');
2774 if (*endp == NULL)
2775 return NULL; /* mismatched quotes */
2776 if ((*endp)[1] != '"')
2777 break; /* found end of quoted identifier */
2778 /* Collapse adjacent quotes into one quote, and look again */
2779 memmove(*endp, *endp + 1, strlen(*endp));
2780 *nextp = *endp;
2781 }
2782 /* *endp now points at the terminating quote */
2783 *nextp = *endp + 1;
2784
2785 return token;
2786}

References fb(), and token.

Referenced by scan_identifier(), and SplitDirectoriesString().

◆ split_part()

Datum split_part ( PG_FUNCTION_ARGS  )

Definition at line 3506 of file varlena.c.

3507{
3510 int fldnum = PG_GETARG_INT32(2);
3511 int inputstring_len;
3512 int fldsep_len;
3514 char *start_ptr;
3515 char *end_ptr;
3517 bool found;
3518
3519 /* field number is 1 based */
3520 if (fldnum == 0)
3521 ereport(ERROR,
3523 errmsg("field position must not be zero")));
3524
3527
3528 /* return empty string for empty input string */
3529 if (inputstring_len < 1)
3531
3532 /* handle empty field separator */
3533 if (fldsep_len < 1)
3534 {
3535 /* if first or last field, return input string, else empty string */
3536 if (fldnum == 1 || fldnum == -1)
3538 else
3540 }
3541
3542 /* find the first field separator */
3544
3545 found = text_position_next(&state);
3546
3547 /* special case if fldsep not found at all */
3548 if (!found)
3549 {
3551 /* if first or last field, return input string, else empty string */
3552 if (fldnum == 1 || fldnum == -1)
3554 else
3556 }
3557
3558 /*
3559 * take care of a negative field number (i.e. count from the right) by
3560 * converting to a positive field number; we need total number of fields
3561 */
3562 if (fldnum < 0)
3563 {
3564 /* we found a fldsep, so there are at least two fields */
3565 int numfields = 2;
3566
3567 while (text_position_next(&state))
3568 numfields++;
3569
3570 /* special case of last field does not require an extra pass */
3571 if (fldnum == -1)
3572 {
3573 start_ptr = text_position_get_match_ptr(&state) + state.last_match_len;
3577 end_ptr - start_ptr));
3578 }
3579
3580 /* else, convert fldnum to positive notation */
3581 fldnum += numfields + 1;
3582
3583 /* if nonexistent field, return empty string */
3584 if (fldnum <= 0)
3585 {
3588 }
3589
3590 /* reset to pointing at first match, but now with positive fldnum */
3592 found = text_position_next(&state);
3593 Assert(found);
3594 }
3595
3596 /* identify bounds of first field */
3599
3600 while (found && --fldnum > 0)
3601 {
3602 /* identify bounds of next field */
3603 start_ptr = end_ptr + state.last_match_len;
3604 found = text_position_next(&state);
3605 if (found)
3607 }
3608
3610
3611 if (fldnum > 0)
3612 {
3613 /* N'th field separator not found */
3614 /* if last field requested, return it, else empty string */
3615 if (fldnum == 1)
3616 {
3618
3621 }
3622 else
3624 }
3625 else
3626 {
3627 /* non-last field requested */
3629 }
3630
3632}
#define PG_GETARG_INT32(n)
Definition fmgr.h:269
static void text_position_reset(TextPositionState *state)
Definition varlena.c:1311

References Assert, cstring_to_text(), cstring_to_text_with_len(), ereport, errcode(), errmsg, ERROR, fb(), PG_GET_COLLATION, PG_GETARG_INT32, PG_GETARG_TEXT_PP, PG_RETURN_TEXT_P, text_position_cleanup(), text_position_get_match_ptr(), text_position_next(), text_position_reset(), text_position_setup(), VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

Referenced by executeStringInternalMethod().

◆ split_text()

static bool split_text ( FunctionCallInfo  fcinfo,
SplitTextOutputData tstate 
)
static

Definition at line 3729 of file varlena.c.

3730{
3732 text *fldsep;
3734 Oid collation = PG_GET_COLLATION();
3735 int inputstring_len;
3736 int fldsep_len;
3737 char *start_ptr;
3739
3740 /* when input string is NULL, then result is NULL too */
3741 if (PG_ARGISNULL(0))
3742 return false;
3743
3745
3746 /* fldsep can be NULL */
3747 if (!PG_ARGISNULL(1))
3749 else
3750 fldsep = NULL;
3751
3752 /* null_string can be NULL or omitted */
3753 if (PG_NARGS() > 2 && !PG_ARGISNULL(2))
3755 else
3756 null_string = NULL;
3757
3758 if (fldsep != NULL)
3759 {
3760 /*
3761 * Normal case with non-null fldsep. Use the text_position machinery
3762 * to search for occurrences of fldsep.
3763 */
3765
3768
3769 /* return empty set for empty input string */
3770 if (inputstring_len < 1)
3771 return true;
3772
3773 /* empty field separator: return input string as a one-element set */
3774 if (fldsep_len < 1)
3775 {
3777 null_string, collation);
3778 return true;
3779 }
3780
3782
3784
3785 for (;;)
3786 {
3787 bool found;
3788 char *end_ptr;
3789 int chunk_len;
3790
3792
3793 found = text_position_next(&state);
3794 if (!found)
3795 {
3796 /* fetch last field */
3798 end_ptr = NULL; /* not used, but some compilers complain */
3799 }
3800 else
3801 {
3802 /* fetch non-last field */
3805 }
3806
3807 /* build a temp text datum to pass to split_text_accum_result */
3809
3810 /* stash away this field */
3812 null_string, collation);
3813
3815
3816 if (!found)
3817 break;
3818
3819 start_ptr = end_ptr + state.last_match_len;
3820 }
3821
3823 }
3824 else
3825 {
3826 const char *end_ptr;
3827
3828 /*
3829 * When fldsep is NULL, each character in the input string becomes a
3830 * separate element in the result set. The separator is effectively
3831 * the space between characters.
3832 */
3834
3837
3838 while (inputstring_len > 0)
3839 {
3841
3843
3844 /* build a temp text datum to pass to split_text_accum_result */
3846
3847 /* stash away this field */
3849 null_string, collation);
3850
3852
3855 }
3856 }
3857
3858 return true;
3859}
int pg_mblen_range(const char *mbstr, const char *end)
Definition mbutils.c:1084
static void split_text_accum_result(SplitTextOutputData *tstate, text *field_value, text *null_string, Oid collation)
Definition varlena.c:3868

References CHECK_FOR_INTERRUPTS, cstring_to_text_with_len(), fb(), pfree(), PG_ARGISNULL, PG_GET_COLLATION, PG_GETARG_TEXT_PP, pg_mblen_range(), PG_NARGS, split_text_accum_result(), text_position_cleanup(), text_position_get_match_ptr(), text_position_next(), text_position_setup(), VARDATA_ANY(), VARSIZE_ANY(), and VARSIZE_ANY_EXHDR().

Referenced by text_to_array(), and text_to_table().

◆ split_text_accum_result()

static void split_text_accum_result ( SplitTextOutputData tstate,
text field_value,
text null_string,
Oid  collation 
)
static

Definition at line 3868 of file varlena.c.

3872{
3873 bool is_null = false;
3874
3875 if (null_string && text_isequal(field_value, null_string, collation))
3876 is_null = true;
3877
3878 if (tstate->tupstore)
3879 {
3880 Datum values[1];
3881 bool nulls[1];
3882
3884 nulls[0] = is_null;
3885
3886 tuplestore_putvalues(tstate->tupstore,
3887 tstate->tupdesc,
3888 values,
3889 nulls);
3890 }
3891 else
3892 {
3893 tstate->astate = accumArrayResult(tstate->astate,
3895 is_null,
3896 TEXTOID,
3898 }
3899}
ArrayBuildState * accumArrayResult(ArrayBuildState *astate, Datum dvalue, bool disnull, Oid element_type, MemoryContext rcontext)
static Datum values[MAXATTR]
Definition bootstrap.c:190
MemoryContext CurrentMemoryContext
Definition mcxt.c:160
void tuplestore_putvalues(Tuplestorestate *state, TupleDesc tdesc, const Datum *values, const bool *isnull)
Definition tuplestore.c:785
static bool text_isequal(text *txt1, text *txt2, Oid collid)
Definition varlena.c:3638

References accumArrayResult(), CurrentMemoryContext, fb(), PointerGetDatum, text_isequal(), tuplestore_putvalues(), and values.

Referenced by split_text().

◆ SplitDirectoriesString()

bool SplitDirectoriesString ( char rawstring,
char  separator,
List **  namelist 
)

Definition at line 2950 of file varlena.c.

2952{
2953 char *nextp = rawstring;
2954 bool done = false;
2955
2956 *namelist = NIL;
2957
2958 while (scanner_isspace(*nextp))
2959 nextp++; /* skip leading whitespace */
2960
2961 if (*nextp == '\0')
2962 return true; /* empty string represents empty list */
2963
2964 /* At the top of the loop, we are at start of a new directory. */
2965 do
2966 {
2967 char *curname;
2968 char *endp;
2969
2970 if (*nextp == '"')
2971 {
2972 /* Quoted name --- collapse quote-quote pairs */
2974 if (curname == NULL)
2975 return false; /* mismatched quotes */
2976 }
2977 else
2978 {
2979 /* Unquoted name --- extends to separator or end of string */
2980 curname = endp = nextp;
2981 while (*nextp && *nextp != separator)
2982 {
2983 /* trailing whitespace should not be included in name */
2984 if (!scanner_isspace(*nextp))
2985 endp = nextp + 1;
2986 nextp++;
2987 }
2988 if (curname == endp)
2989 return false; /* empty unquoted name not allowed */
2990 }
2991
2992 while (scanner_isspace(*nextp))
2993 nextp++; /* skip trailing whitespace */
2994
2995 if (*nextp == separator)
2996 {
2997 nextp++;
2998 while (scanner_isspace(*nextp))
2999 nextp++; /* skip leading whitespace for next */
3000 /* we expect another name, so done remains false */
3001 }
3002 else if (*nextp == '\0')
3003 done = true;
3004 else
3005 return false; /* invalid syntax */
3006
3007 /* Now safe to overwrite separator with a null */
3008 *endp = '\0';
3009
3010 /* Truncate path if it's overlength */
3011 if (strlen(curname) >= MAXPGPATH)
3012 curname[MAXPGPATH - 1] = '\0';
3013
3014 /*
3015 * Finished isolating current name --- add it to list
3016 */
3020
3021 /* Loop back if we didn't reach end of string */
3022 } while (!done);
3023
3024 return true;
3025}
List * lappend(List *list, void *datum)
Definition list.c:339
char * pstrdup(const char *in)
Definition mcxt.c:1781
#define MAXPGPATH
#define NIL
Definition pg_list.h:68
void canonicalize_path(char *path)
Definition path.c:337

References canonicalize_path(), fb(), lappend(), MAXPGPATH, NIL, pstrdup(), scan_quoted_identifier(), and scanner_isspace().

Referenced by check_oauth_validator(), load_libraries(), and PostmasterMain().

◆ SplitGUCList()

bool SplitGUCList ( char rawstring,
char  separator,
List **  namelist 
)

Definition at line 3060 of file varlena.c.

3062{
3063 char *nextp = rawstring;
3064 bool done = false;
3065
3066 *namelist = NIL;
3067
3068 while (scanner_isspace(*nextp))
3069 nextp++; /* skip leading whitespace */
3070
3071 if (*nextp == '\0')
3072 return true; /* empty string represents empty list */
3073
3074 /* At the top of the loop, we are at start of a new identifier. */
3075 do
3076 {
3077 char *curname;
3078 char *endp;
3079
3081 if (curname == NULL)
3082 return false; /* mismatched quotes or empty name */
3083
3084 while (scanner_isspace(*nextp))
3085 nextp++; /* skip trailing whitespace */
3086
3087 if (*nextp == separator)
3088 {
3089 nextp++;
3090 while (scanner_isspace(*nextp))
3091 nextp++; /* skip leading whitespace for next */
3092 /* we expect another name, so done remains false */
3093 }
3094 else if (*nextp == '\0')
3095 done = true;
3096 else
3097 return false; /* invalid syntax */
3098
3099 /* Now safe to overwrite separator with a null */
3100 *endp = '\0';
3101
3102 /*
3103 * Finished isolating current name --- add it to list
3104 */
3106
3107 /* Loop back if we didn't reach end of string */
3108 } while (!done);
3109
3110 return true;
3111}
char * scan_identifier(char **endp, char **nextp, char separator, bool downcase_unquoted)
Definition varlena.c:2802

References fb(), lappend(), NIL, scan_identifier(), and scanner_isspace().

Referenced by append_guc_value(), check_debug_io_direct(), check_log_min_messages(), dumpFunc(), pg_get_functiondef(), and PostmasterMain().

◆ SplitIdentifierString()

bool SplitIdentifierString ( char rawstring,
char  separator,
List **  namelist 
)

Definition at line 2867 of file varlena.c.

2869{
2870 char *nextp = rawstring;
2871 bool done = false;
2872
2873 *namelist = NIL;
2874
2875 while (scanner_isspace(*nextp))
2876 nextp++; /* skip leading whitespace */
2877
2878 if (*nextp == '\0')
2879 return true; /* empty string represents empty list */
2880
2881 /* At the top of the loop, we are at start of a new identifier. */
2882 do
2883 {
2884 char *curname;
2885 char *endp;
2886
2888 if (curname == NULL)
2889 return false; /* mismatched quotes or empty name */
2890
2891 while (scanner_isspace(*nextp))
2892 nextp++; /* skip trailing whitespace */
2893
2894 if (*nextp == separator)
2895 {
2896 nextp++;
2897 while (scanner_isspace(*nextp))
2898 nextp++; /* skip leading whitespace for next */
2899 /* we expect another name, so done remains false */
2900 }
2901 else if (*nextp == '\0')
2902 done = true;
2903 else
2904 return false; /* invalid syntax */
2905
2906 /* Now safe to overwrite separator with a null */
2907 *endp = '\0';
2908
2909 /* Truncate name if it's overlength */
2911
2912 /*
2913 * Finished isolating current name --- add it to list
2914 */
2916
2917 /* Loop back if we didn't reach end of string */
2918 } while (!done);
2919
2920 return true;
2921}
void truncate_identifier(char *ident, int len, bool warn)
Definition scansup.c:81

References fb(), lappend(), NIL, scan_identifier(), scanner_isspace(), and truncate_identifier().

Referenced by check_createrole_self_grant(), check_datestyle(), check_log_connections(), check_log_destination(), check_restrict_nonsystem_relation_kind(), check_search_path(), check_temp_tablespaces(), check_wal_consistency_checking(), ExtractExtensionList(), parse_extension_control_file(), parse_output_parameters(), parse_publication_options(), plpgsql_extra_checks_check_hook(), PrepareTempTablespaces(), preprocessNamespacePath(), stringToQualifiedNameList(), textToQualifiedNameList(), and validate_sync_standby_slots().

◆ string_agg_combine()

Datum string_agg_combine ( PG_FUNCTION_ARGS  )

Definition at line 4384 of file varlena.c.

4385{
4388 MemoryContext agg_context;
4389
4390 if (!AggCheckCallContext(fcinfo, &agg_context))
4391 elog(ERROR, "aggregate function called in non-aggregate context");
4392
4395
4396 if (state2 == NULL)
4397 {
4398 /*
4399 * NULL state2 is easy, just return state1, which we know is already
4400 * in the agg_context
4401 */
4402 if (state1 == NULL)
4405 }
4406
4407 if (state1 == NULL)
4408 {
4409 /* We must copy state2's data into the agg_context */
4411
4412 old_context = MemoryContextSwitchTo(agg_context);
4413 state1 = makeStringAggState(fcinfo);
4415 state1->cursor = state2->cursor;
4417 }
4418 else if (state2->len > 0)
4419 {
4420 /* Combine ... state1->cursor does not change in this case */
4422 }
4423
4425}
#define PG_RETURN_POINTER(x)
Definition fmgr.h:363
struct StringInfoData * StringInfo
Definition string.h:15
static StringInfo makeStringAggState(FunctionCallInfo fcinfo)
Definition varlena.c:4305

References AggCheckCallContext(), appendBinaryStringInfo(), elog, ERROR, fb(), makeStringAggState(), MemoryContextSwitchTo(), PG_ARGISNULL, PG_GETARG_POINTER, PG_RETURN_NULL, and PG_RETURN_POINTER.

◆ string_agg_deserialize()

Datum string_agg_deserialize ( PG_FUNCTION_ARGS  )

Definition at line 4465 of file varlena.c.

4466{
4467 bytea *sstate;
4470 char *data;
4471 int datalen;
4472
4473 /* cannot be called directly because of internal-type argument */
4475
4476 sstate = PG_GETARG_BYTEA_PP(0);
4477
4478 /*
4479 * Initialize a StringInfo so that we can "receive" it using the standard
4480 * recv-function infrastructure.
4481 */
4483 VARSIZE_ANY_EXHDR(sstate));
4484
4485 result = makeStringAggState(fcinfo);
4486
4487 /* cursor */
4488 result->cursor = pq_getmsgint(&buf, 4);
4489
4490 /* data */
4491 datalen = VARSIZE_ANY_EXHDR(sstate) - 4;
4492 data = (char *) pq_getmsgbytes(&buf, datalen);
4494
4495 pq_getmsgend(&buf);
4496
4498}
#define PG_GETARG_BYTEA_PP(n)
Definition fmgr.h:309
unsigned int pq_getmsgint(StringInfo msg, int b)
Definition pqformat.c:414
void pq_getmsgend(StringInfo msg)
Definition pqformat.c:634
const char * pq_getmsgbytes(StringInfo msg, int datalen)
Definition pqformat.c:507
static void initReadOnlyStringInfo(StringInfo str, char *data, int len)
Definition stringinfo.h:157

References AggCheckCallContext(), appendBinaryStringInfo(), Assert, buf, data, fb(), initReadOnlyStringInfo(), makeStringAggState(), PG_GETARG_BYTEA_PP, PG_RETURN_POINTER, pq_getmsgbytes(), pq_getmsgend(), pq_getmsgint(), result, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

◆ string_agg_finalfn()

Datum string_agg_finalfn ( PG_FUNCTION_ARGS  )

Definition at line 4501 of file varlena.c.

4502{
4504
4505 /* cannot be called directly because of internal-type argument */
4507
4509
4510 if (state != NULL)
4511 {
4512 /* As per comment in transfn, strip data before the cursor position */
4514 state->len - state->cursor));
4515 }
4516 else
4518}

References AggCheckCallContext(), Assert, cstring_to_text_with_len(), fb(), PG_ARGISNULL, PG_GETARG_POINTER, PG_RETURN_NULL, and PG_RETURN_TEXT_P.

◆ string_agg_serialize()

Datum string_agg_serialize ( PG_FUNCTION_ARGS  )

Definition at line 4434 of file varlena.c.

4435{
4438 bytea *result;
4439
4440 /* cannot be called directly because of internal-type argument */
4442
4444
4446
4447 /* cursor */
4448 pq_sendint(&buf, state->cursor, 4);
4449
4450 /* data */
4451 pq_sendbytes(&buf, state->data, state->len);
4452
4454
4456}
#define PG_RETURN_BYTEA_P(x)
Definition fmgr.h:373
void pq_sendbytes(StringInfo buf, const void *data, int datalen)
Definition pqformat.c:126
void pq_begintypsend(StringInfo buf)
Definition pqformat.c:325
bytea * pq_endtypsend(StringInfo buf)
Definition pqformat.c:345
static void pq_sendint(StringInfo buf, uint32 i, int b)
Definition pqformat.h:171

References AggCheckCallContext(), Assert, buf, fb(), PG_GETARG_POINTER, PG_RETURN_BYTEA_P, pq_begintypsend(), pq_endtypsend(), pq_sendbytes(), pq_sendint(), and result.

◆ string_agg_transfn()

Datum string_agg_transfn ( PG_FUNCTION_ARGS  )

Definition at line 4329 of file varlena.c.

4330{
4332
4334
4335 /* Append the value unless null, preceding it with the delimiter. */
4336 if (!PG_ARGISNULL(1))
4337 {
4339 bool isfirst = false;
4340
4341 /*
4342 * You might think we can just throw away the first delimiter, however
4343 * we must keep it as we may be a parallel worker doing partial
4344 * aggregation building a state to send to the main process. We need
4345 * to keep the delimiter of every aggregation so that the combine
4346 * function can properly join up the strings of two separately
4347 * partially aggregated results. The first delimiter is only stripped
4348 * off in the final function. To know how much to strip off the front
4349 * of the string, we store the length of the first delimiter in the
4350 * StringInfo's cursor field, which we don't otherwise need here.
4351 */
4352 if (state == NULL)
4353 {
4354 state = makeStringAggState(fcinfo);
4355 isfirst = true;
4356 }
4357
4358 if (!PG_ARGISNULL(2))
4359 {
4360 text *delim = PG_GETARG_TEXT_PP(2);
4361
4363 if (isfirst)
4364 state->cursor = VARSIZE_ANY_EXHDR(delim);
4365 }
4366
4368 }
4369
4370 /*
4371 * The transition type for string_agg() is declared to be "internal",
4372 * which is a pass-by-value type the same size as a pointer.
4373 */
4374 if (state)
4377}

References appendStringInfoText(), fb(), makeStringAggState(), PG_ARGISNULL, PG_GETARG_POINTER, PG_GETARG_TEXT_PP, PG_RETURN_NULL, PG_RETURN_POINTER, value, and VARSIZE_ANY_EXHDR().

◆ text_catenate()

static text * text_catenate ( text t1,
text t2 
)
static

Definition at line 463 of file varlena.c.

464{
465 text *result;
466 int len1,
467 len2,
468 len;
469 char *ptr;
470
471 len1 = VARSIZE_ANY_EXHDR(t1);
472 len2 = VARSIZE_ANY_EXHDR(t2);
473
474 /* paranoia ... probably should throw error instead? */
475 if (len1 < 0)
476 len1 = 0;
477 if (len2 < 0)
478 len2 = 0;
479
480 len = len1 + len2 + VARHDRSZ;
481 result = (text *) palloc(len);
482
483 /* Set size of result string... */
485
486 /* Fill data field of result string... */
487 ptr = VARDATA(result);
488 if (len1 > 0)
489 memcpy(ptr, VARDATA_ANY(t1), len1);
490 if (len2 > 0)
491 memcpy(ptr + len1, VARDATA_ANY(t2), len2);
492
493 return result;
494}

References fb(), len, memcpy(), palloc(), result, SET_VARSIZE(), VARDATA(), VARDATA_ANY(), VARHDRSZ, and VARSIZE_ANY_EXHDR().

Referenced by text_overlay(), and textcat().

◆ text_cmp()

static int text_cmp ( text arg1,
text arg2,
Oid  collid 
)
static

Definition at line 1403 of file varlena.c.

1404{
1405 char *a1p,
1406 *a2p;
1407 int len1,
1408 len2;
1409
1410 a1p = VARDATA_ANY(arg1);
1411 a2p = VARDATA_ANY(arg2);
1412
1413 len1 = VARSIZE_ANY_EXHDR(arg1);
1414 len2 = VARSIZE_ANY_EXHDR(arg2);
1415
1416 return varstr_cmp(a1p, len1, a2p, len2, collid);
1417}

References collid, fb(), VARDATA_ANY(), VARSIZE_ANY_EXHDR(), and varstr_cmp().

Referenced by bttextcmp(), text_ge(), text_gt(), text_larger(), text_le(), text_lt(), text_smaller(), texteq(), and textne().

◆ text_concat()

Datum text_concat ( PG_FUNCTION_ARGS  )

Definition at line 4645 of file varlena.c.

4646{
4647 text *result;
4648
4649 result = concat_internal("", 0, fcinfo);
4650 if (result == NULL)
4653}
static text * concat_internal(const char *sepstr, int argidx, FunctionCallInfo fcinfo)
Definition varlena.c:4565

References concat_internal(), fb(), PG_RETURN_NULL, PG_RETURN_TEXT_P, and result.

◆ text_concat_ws()

Datum text_concat_ws ( PG_FUNCTION_ARGS  )

Definition at line 4660 of file varlena.c.

4661{
4662 char *sep;
4663 text *result;
4664
4665 /* return NULL when separator is NULL */
4666 if (PG_ARGISNULL(0))
4669
4670 result = concat_internal(sep, 1, fcinfo);
4671 if (result == NULL)
4674}

References concat_internal(), fb(), PG_ARGISNULL, PG_GETARG_TEXT_PP, PG_RETURN_NULL, PG_RETURN_TEXT_P, result, and text_to_cstring().

◆ text_format()

Datum text_format ( PG_FUNCTION_ARGS  )

Definition at line 4781 of file varlena.c.

4782{
4783 text *fmt;
4785 const char *cp;
4786 const char *start_ptr;
4787 const char *end_ptr;
4788 text *result;
4789 int arg;
4790 bool funcvariadic;
4791 int nargs;
4792 Datum *elements = NULL;
4793 bool *nulls = NULL;
4794 Oid element_type = InvalidOid;
4799
4800 /* When format string is null, immediately return null */
4801 if (PG_ARGISNULL(0))
4803
4804 /* If argument is marked VARIADIC, expand array into elements */
4805 if (get_fn_expr_variadic(fcinfo->flinfo))
4806 {
4807 ArrayType *arr;
4808 int16 elmlen;
4809 bool elmbyval;
4810 char elmalign;
4811 int nitems;
4812
4813 /* Should have just the one argument */
4814 Assert(PG_NARGS() == 2);
4815
4816 /* If argument is NULL, we treat it as zero-length array */
4817 if (PG_ARGISNULL(1))
4818 nitems = 0;
4819 else
4820 {
4821 /*
4822 * Non-null argument had better be an array. We assume that any
4823 * call context that could let get_fn_expr_variadic return true
4824 * will have checked that a VARIADIC-labeled parameter actually is
4825 * an array. So it should be okay to just Assert that it's an
4826 * array rather than doing a full-fledged error check.
4827 */
4829
4830 /* OK, safe to fetch the array value */
4831 arr = PG_GETARG_ARRAYTYPE_P(1);
4832
4833 /* Get info about array element type */
4834 element_type = ARR_ELEMTYPE(arr);
4835 get_typlenbyvalalign(element_type,
4836 &elmlen, &elmbyval, &elmalign);
4837
4838 /* Extract all array elements */
4839 deconstruct_array(arr, element_type, elmlen, elmbyval, elmalign,
4840 &elements, &nulls, &nitems);
4841 }
4842
4843 nargs = nitems + 1;
4844 funcvariadic = true;
4845 }
4846 else
4847 {
4848 /* Non-variadic case, we'll process the arguments individually */
4849 nargs = PG_NARGS();
4850 funcvariadic = false;
4851 }
4852
4853 /* Setup for main loop. */
4858 arg = 1; /* next argument position to print */
4859
4860 /* Scan format string, looking for conversion specifiers. */
4861 for (cp = start_ptr; cp < end_ptr; cp++)
4862 {
4863 int argpos;
4864 int widthpos;
4865 int flags;
4866 int width;
4867 Datum value;
4868 bool isNull;
4869 Oid typid;
4870
4871 /*
4872 * If it's not the start of a conversion specifier, just copy it to
4873 * the output buffer.
4874 */
4875 if (*cp != '%')
4876 {
4878 continue;
4879 }
4880
4882
4883 /* Easy case: %% outputs a single % */
4884 if (*cp == '%')
4885 {
4887 continue;
4888 }
4889
4890 /* Parse the optional portions of the format specifier */
4892 &argpos, &widthpos,
4893 &flags, &width);
4894
4895 /*
4896 * Next we should see the main conversion specifier. Whether or not
4897 * an argument position was present, it's known that at least one
4898 * character remains in the string at this point. Experience suggests
4899 * that it's worth checking that that character is one of the expected
4900 * ones before we try to fetch arguments, so as to produce the least
4901 * confusing response to a mis-formatted specifier.
4902 */
4903 if (strchr("sIL", *cp) == NULL)
4904 ereport(ERROR,
4906 errmsg("unrecognized format() type specifier \"%.*s\"",
4908 errhint("For a single \"%%\" use \"%%%%\".")));
4909
4910 /* If indirect width was specified, get its value */
4911 if (widthpos >= 0)
4912 {
4913 /* Collect the specified or next argument position */
4914 if (widthpos > 0)
4915 arg = widthpos;
4916 if (arg >= nargs)
4917 ereport(ERROR,
4919 errmsg("too few arguments for format()")));
4920
4921 /* Get the value and type of the selected argument */
4922 if (!funcvariadic)
4923 {
4925 isNull = PG_ARGISNULL(arg);
4926 typid = get_fn_expr_argtype(fcinfo->flinfo, arg);
4927 }
4928 else
4929 {
4930 value = elements[arg - 1];
4931 isNull = nulls[arg - 1];
4932 typid = element_type;
4933 }
4934 if (!OidIsValid(typid))
4935 elog(ERROR, "could not determine data type of format() input");
4936
4937 arg++;
4938
4939 /* We can treat NULL width the same as zero */
4940 if (isNull)
4941 width = 0;
4942 else if (typid == INT4OID)
4943 width = DatumGetInt32(value);
4944 else if (typid == INT2OID)
4945 width = DatumGetInt16(value);
4946 else
4947 {
4948 /* For less-usual datatypes, convert to text then to int */
4949 char *str;
4950
4951 if (typid != prev_width_type)
4952 {
4954 bool typIsVarlena;
4955
4958 prev_width_type = typid;
4959 }
4960
4962
4963 /* pg_strtoint32 will complain about bad data or overflow */
4964 width = pg_strtoint32(str);
4965
4966 pfree(str);
4967 }
4968 }
4969
4970 /* Collect the specified or next argument position */
4971 if (argpos > 0)
4972 arg = argpos;
4973 if (arg >= nargs)
4974 ereport(ERROR,
4976 errmsg("too few arguments for format()")));
4977
4978 /* Get the value and type of the selected argument */
4979 if (!funcvariadic)
4980 {
4982 isNull = PG_ARGISNULL(arg);
4983 typid = get_fn_expr_argtype(fcinfo->flinfo, arg);
4984 }
4985 else
4986 {
4987 value = elements[arg - 1];
4988 isNull = nulls[arg - 1];
4989 typid = element_type;
4990 }
4991 if (!OidIsValid(typid))
4992 elog(ERROR, "could not determine data type of format() input");
4993
4994 arg++;
4995
4996 /*
4997 * Get the appropriate typOutput function, reusing previous one if
4998 * same type as previous argument. That's particularly useful in the
4999 * variadic-array case, but often saves work even for ordinary calls.
5000 */
5001 if (typid != prev_type)
5002 {
5004 bool typIsVarlena;
5005
5008 prev_type = typid;
5009 }
5010
5011 /*
5012 * And now we can format the value.
5013 */
5014 switch (*cp)
5015 {
5016 case 's':
5017 case 'I':
5018 case 'L':
5020 value, isNull,
5021 flags, width);
5022 break;
5023 default:
5024 /* should not get here, because of previous check */
5025 ereport(ERROR,
5027 errmsg("unrecognized format() type specifier \"%.*s\"",
5029 errhint("For a single \"%%\" use \"%%%%\".")));
5030 break;
5031 }
5032 }
5033
5034 /* Don't need deconstruct_array results anymore. */
5035 if (elements != NULL)
5036 pfree(elements);
5037 if (nulls != NULL)
5038 pfree(nulls);
5039
5040 /* Generate results. */
5042 pfree(str.data);
5043
5045}
void deconstruct_array(const ArrayType *array, Oid elmtype, int elmlen, bool elmbyval, char elmalign, Datum **elemsp, bool **nullsp, int *nelemsp)
int16_t int16
Definition c.h:619
Datum arg
Definition elog.c:1323
void fmgr_info(Oid functionId, FmgrInfo *finfo)
Definition fmgr.c:129
void get_typlenbyvalalign(Oid typid, int16 *typlen, bool *typbyval, char *typalign)
Definition lsyscache.c:2464
int32 pg_strtoint32(const char *s)
Definition numutils.c:382
static int16 DatumGetInt16(Datum X)
Definition postgres.h:162
#define InvalidOid
#define appendStringInfoCharMacro(str, ch)
Definition stringinfo.h:231
static void text_format_string_conversion(StringInfo buf, char conversion, FmgrInfo *typOutputInfo, Datum value, bool isNull, int flags, int width)
Definition varlena.c:5184
static const char * text_format_parse_format(const char *start_ptr, const char *end_ptr, int *argpos, int *widthpos, int *flags, int *width)
Definition varlena.c:5107
#define ADVANCE_PARSE_POINTER(ptr, end_ptr)
Definition varlena.c:4768

References ADVANCE_PARSE_POINTER, appendStringInfoCharMacro, arg, ARR_ELEMTYPE, Assert, cstring_to_text_with_len(), DatumGetInt16(), DatumGetInt32(), deconstruct_array(), elog, ereport, errcode(), errhint(), errmsg, ERROR, fb(), fmgr_info(), get_base_element_type(), get_fn_expr_argtype(), get_fn_expr_variadic(), get_typlenbyvalalign(), getTypeOutputInfo(), initStringInfo(), InvalidOid, nitems, OidIsValid, OutputFunctionCall(), pfree(), PG_ARGISNULL, PG_GETARG_ARRAYTYPE_P, PG_GETARG_DATUM, PG_GETARG_TEXT_PP, pg_mblen_range(), PG_NARGS, PG_RETURN_NULL, PG_RETURN_TEXT_P, pg_strtoint32(), result, str, text_format_parse_format(), text_format_string_conversion(), value, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

Referenced by text_format_nv().

◆ text_format_append_string()

static void text_format_append_string ( StringInfo  buf,
const char str,
int  flags,
int  width 
)
static

Definition at line 5233 of file varlena.c.

5235{
5236 bool align_to_left = false;
5237 int len;
5238
5239 /* fast path for typical easy case */
5240 if (width == 0)
5241 {
5243 return;
5244 }
5245
5246 if (width < 0)
5247 {
5248 /* Negative width: implicit '-' flag, then take absolute value */
5249 align_to_left = true;
5250 /* -INT_MIN is undefined */
5251 if (width <= INT_MIN)
5252 ereport(ERROR,
5254 errmsg("number is out of range")));
5255 width = -width;
5256 }
5257 else if (flags & TEXT_FORMAT_FLAG_MINUS)
5258 align_to_left = true;
5259
5260 len = pg_mbstrlen(str);
5261 if (align_to_left)
5262 {
5263 /* left justify */
5265 if (len < width)
5266 appendStringInfoSpaces(buf, width - len);
5267 }
5268 else
5269 {
5270 /* right justify */
5271 if (len < width)
5272 appendStringInfoSpaces(buf, width - len);
5274 }
5275}
int pg_mbstrlen(const char *mbstr)
Definition mbutils.c:1165
void appendStringInfoSpaces(StringInfo str, int count)
Definition stringinfo.c:260
#define TEXT_FORMAT_FLAG_MINUS
Definition varlena.c:4766

References appendStringInfoSpaces(), appendStringInfoString(), buf, ereport, errcode(), errmsg, ERROR, fb(), len, pg_mbstrlen(), str, and TEXT_FORMAT_FLAG_MINUS.

Referenced by text_format_string_conversion().

◆ text_format_nv()

Datum text_format_nv ( PG_FUNCTION_ARGS  )

Definition at line 5285 of file varlena.c.

5286{
5287 return text_format(fcinfo);
5288}
Datum text_format(PG_FUNCTION_ARGS)
Definition varlena.c:4781

References text_format().

◆ text_format_parse_digits()

static bool text_format_parse_digits ( const char **  ptr,
const char end_ptr,
int value 
)
static

Definition at line 5058 of file varlena.c.

5059{
5060 bool found = false;
5061 const char *cp = *ptr;
5062 int val = 0;
5063
5064 while (*cp >= '0' && *cp <= '9')
5065 {
5066 int8 digit = (*cp - '0');
5067
5068 if (unlikely(pg_mul_s32_overflow(val, 10, &val)) ||
5070 ereport(ERROR,
5072 errmsg("number is out of range")));
5074 found = true;
5075 }
5076
5077 *ptr = cp;
5078 *value = val;
5079
5080 return found;
5081}
int8_t int8
Definition c.h:618
#define unlikely(x)
Definition c.h:438
long val
Definition informix.c:689
static bool pg_mul_s32_overflow(int32 a, int32 b, int32 *result)
Definition int.h:187
static bool pg_add_s32_overflow(int32 a, int32 b, int32 *result)
Definition int.h:151

References ADVANCE_PARSE_POINTER, ereport, errcode(), errmsg, ERROR, fb(), pg_add_s32_overflow(), pg_mul_s32_overflow(), unlikely, val, and value.

Referenced by text_format_parse_format().

◆ text_format_parse_format()

static const char * text_format_parse_format ( const char start_ptr,
const char end_ptr,
int argpos,
int widthpos,
int flags,
int width 
)
static

Definition at line 5107 of file varlena.c.

5110{
5111 const char *cp = start_ptr;
5112 int n;
5113
5114 /* set defaults for output parameters */
5115 *argpos = -1;
5116 *widthpos = -1;
5117 *flags = 0;
5118 *width = 0;
5119
5120 /* try to identify first number */
5122 {
5123 if (*cp != '$')
5124 {
5125 /* Must be just a width and a type, so we're done */
5126 *width = n;
5127 return cp;
5128 }
5129 /* The number was argument position */
5130 *argpos = n;
5131 /* Explicit 0 for argument index is immediately refused */
5132 if (n == 0)
5133 ereport(ERROR,
5135 errmsg("format specifies argument 0, but arguments are numbered from 1")));
5137 }
5138
5139 /* Handle flags (only minus is supported now) */
5140 while (*cp == '-')
5141 {
5142 *flags |= TEXT_FORMAT_FLAG_MINUS;
5144 }
5145
5146 if (*cp == '*')
5147 {
5148 /* Handle indirect width */
5151 {
5152 /* number in this position must be closed by $ */
5153 if (*cp != '$')
5154 ereport(ERROR,
5156 errmsg("width argument position must be ended by \"$\"")));
5157 /* The number was width argument position */
5158 *widthpos = n;
5159 /* Explicit 0 for argument index is immediately refused */
5160 if (n == 0)
5161 ereport(ERROR,
5163 errmsg("format specifies argument 0, but arguments are numbered from 1")));
5165 }
5166 else
5167 *widthpos = 0; /* width's argument position is unspecified */
5168 }
5169 else
5170 {
5171 /* Check for direct width specification */
5173 *width = n;
5174 }
5175
5176 /* cp should now be pointing at type character */
5177 return cp;
5178}
static bool text_format_parse_digits(const char **ptr, const char *end_ptr, int *value)
Definition varlena.c:5058

References ADVANCE_PARSE_POINTER, ereport, errcode(), errmsg, ERROR, fb(), TEXT_FORMAT_FLAG_MINUS, and text_format_parse_digits().

Referenced by text_format().

◆ text_format_string_conversion()

static void text_format_string_conversion ( StringInfo  buf,
char  conversion,
FmgrInfo typOutputInfo,
Datum  value,
bool  isNull,
int  flags,
int  width 
)
static

Definition at line 5184 of file varlena.c.

5188{
5189 char *str;
5190
5191 /* Handle NULL arguments before trying to stringify the value. */
5192 if (isNull)
5193 {
5194 if (conversion == 's')
5195 text_format_append_string(buf, "", flags, width);
5196 else if (conversion == 'L')
5197 text_format_append_string(buf, "NULL", flags, width);
5198 else if (conversion == 'I')
5199 ereport(ERROR,
5201 errmsg("null values cannot be formatted as an SQL identifier")));
5202 return;
5203 }
5204
5205 /* Stringify. */
5207
5208 /* Escape. */
5209 if (conversion == 'I')
5210 {
5211 /* quote_identifier may or may not allocate a new string. */
5213 }
5214 else if (conversion == 'L')
5215 {
5216 char *qstr = quote_literal_cstr(str);
5217
5218 text_format_append_string(buf, qstr, flags, width);
5219 /* quote_literal_cstr() always allocates a new string */
5220 pfree(qstr);
5221 }
5222 else
5223 text_format_append_string(buf, str, flags, width);
5224
5225 /* Cleanup. */
5226 pfree(str);
5227}
char * quote_literal_cstr(const char *rawstr)
Definition quote.c:101
const char * quote_identifier(const char *ident)
static void text_format_append_string(StringInfo buf, const char *str, int flags, int width)
Definition varlena.c:5233

References buf, ereport, errcode(), errmsg, ERROR, fb(), OutputFunctionCall(), pfree(), quote_identifier(), quote_literal_cstr(), str, text_format_append_string(), and value.

Referenced by text_format().

◆ text_ge()

Datum text_ge ( PG_FUNCTION_ARGS  )

Definition at line 1577 of file varlena.c.

1578{
1581 bool result;
1582
1584
1587
1589}

References fb(), PG_FREE_IF_COPY, PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, and text_cmp().

Referenced by gbt_textge().

◆ text_gt()

Datum text_gt ( PG_FUNCTION_ARGS  )

Definition at line 1562 of file varlena.c.

1563{
1566 bool result;
1567
1569
1572
1574}

References fb(), PG_FREE_IF_COPY, PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, and text_cmp().

Referenced by gbt_textgt().

◆ text_isequal()

static bool text_isequal ( text txt1,
text txt2,
Oid  collid 
)
static

Definition at line 3638 of file varlena.c.

3639{
3641 collid,
3644}
static bool DatumGetBool(Datum X)
Definition postgres.h:100
Datum texteq(PG_FUNCTION_ARGS)
Definition varlena.c:1428

References collid, DatumGetBool(), DirectFunctionCall2Coll(), fb(), PointerGetDatum, and texteq().

Referenced by split_text_accum_result().

◆ text_larger()

Datum text_larger ( PG_FUNCTION_ARGS  )

Definition at line 2331 of file varlena.c.

2332{
2335 text *result;
2336
2337 result = ((text_cmp(arg1, arg2, PG_GET_COLLATION()) > 0) ? arg1 : arg2);
2338
2340}

References fb(), PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_TEXT_P, result, and text_cmp().

◆ text_le()

Datum text_le ( PG_FUNCTION_ARGS  )

Definition at line 1547 of file varlena.c.

1548{
1551 bool result;
1552
1554
1557
1559}

References fb(), PG_FREE_IF_COPY, PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, and text_cmp().

Referenced by gbt_textle().

◆ text_left()

Datum text_left ( PG_FUNCTION_ARGS  )

Definition at line 4681 of file varlena.c.

4682{
4683 int n = PG_GETARG_INT32(1);
4684
4685 if (n < 0)
4686 {
4688 const char *p = VARDATA_ANY(str);
4689 int len = VARSIZE_ANY_EXHDR(str);
4690 int rlen;
4691
4692 n = pg_mbstrlen_with_len(p, len) + n;
4693 rlen = pg_mbcharcliplen(p, len, n);
4695 }
4696 else
4698}
int pg_mbstrlen_with_len(const char *mbstr, int limit)
Definition mbutils.c:1185
int pg_mbcharcliplen(const char *mbstr, int len, int limit)
Definition mbutils.c:1253
static text * text_substring(Datum str, int32 start, int32 length, bool length_not_specified)
Definition varlena.c:586

References cstring_to_text_with_len(), fb(), len, PG_GETARG_DATUM, PG_GETARG_INT32, PG_GETARG_TEXT_PP, pg_mbcharcliplen(), pg_mbstrlen_with_len(), PG_RETURN_TEXT_P, str, text_substring(), VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

◆ text_length()

static int32 text_length ( Datum  str)
static

Definition at line 410 of file varlena.c.

411{
412 /* fastpath when max encoding length is one */
415 else
416 {
417 text *t = DatumGetTextPP(str);
418
420 }
421}
Size toast_raw_datum_size(Datum value)
Definition detoast.c:545
#define DatumGetTextPP(X)
Definition fmgr.h:293

References DatumGetTextPP, pg_database_encoding_max_length(), pg_mbstrlen_with_len(), str, toast_raw_datum_size(), VARDATA_ANY(), VARHDRSZ, and VARSIZE_ANY_EXHDR().

Referenced by textlen(), and textoverlay_no_len().

◆ text_lt()

Datum text_lt ( PG_FUNCTION_ARGS  )

Definition at line 1532 of file varlena.c.

1533{
1536 bool result;
1537
1539
1542
1544}

References fb(), PG_FREE_IF_COPY, PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, and text_cmp().

Referenced by gbt_textlt().

◆ text_name()

Datum text_name ( PG_FUNCTION_ARGS  )

Definition at line 2679 of file varlena.c.

2680{
2681 text *s = PG_GETARG_TEXT_PP(0);
2682 Name result;
2683 int len;
2684
2686
2687 /* Truncate oversize input */
2688 if (len >= NAMEDATALEN)
2690
2691 /* We use palloc0 here to ensure result is zero-padded */
2694
2696}
NameData * Name
Definition c.h:833
#define PG_RETURN_NAME(x)
Definition fmgr.h:365
int pg_mbcliplen(const char *mbstr, int len, int limit)
Definition mbutils.c:1211
void * palloc0(Size size)
Definition mcxt.c:1417

References len, memcpy(), NAMEDATALEN, NameStr, palloc0(), PG_GETARG_TEXT_PP, pg_mbcliplen(), PG_RETURN_NAME, result, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

◆ text_overlay()

static text * text_overlay ( text t1,
text t2,
int  sp,
int  sl 
)
static

Definition at line 856 of file varlena.c.

857{
858 text *result;
859 text *s1;
860 text *s2;
861 int sp_pl_sl;
862
863 /*
864 * Check for possible integer-overflow cases. For negative sp, throw a
865 * "substring length" error because that's what should be expected
866 * according to the spec's definition of OVERLAY().
867 */
868 if (sp <= 0)
871 errmsg("negative substring length not allowed")));
875 errmsg("integer out of range")));
876
877 s1 = text_substring(PointerGetDatum(t1), 1, sp - 1, false);
881
882 return result;
883}
static text * text_catenate(text *t1, text *t2)
Definition varlena.c:463

References ereport, errcode(), errmsg, ERROR, fb(), pg_add_s32_overflow(), PointerGetDatum, result, s1, s2, text_catenate(), and text_substring().

Referenced by textoverlay(), and textoverlay_no_len().

◆ text_pattern_ge()

Datum text_pattern_ge ( PG_FUNCTION_ARGS  )

Definition at line 2611 of file varlena.c.

2612{
2615 int result;
2616
2618
2621
2622 PG_RETURN_BOOL(result >= 0);
2623}

References fb(), internal_text_pattern_compare(), PG_FREE_IF_COPY, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, and result.

◆ text_pattern_gt()

Datum text_pattern_gt ( PG_FUNCTION_ARGS  )

Definition at line 2627 of file varlena.c.

2628{
2631 int result;
2632
2634
2637
2639}

References fb(), internal_text_pattern_compare(), PG_FREE_IF_COPY, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, and result.

◆ text_pattern_le()

Datum text_pattern_le ( PG_FUNCTION_ARGS  )

Definition at line 2595 of file varlena.c.

2596{
2599 int result;
2600
2602
2605
2606 PG_RETURN_BOOL(result <= 0);
2607}

References fb(), internal_text_pattern_compare(), PG_FREE_IF_COPY, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, and result.

◆ text_pattern_lt()

Datum text_pattern_lt ( PG_FUNCTION_ARGS  )

Definition at line 2579 of file varlena.c.

2580{
2583 int result;
2584
2586
2589
2591}

References fb(), internal_text_pattern_compare(), PG_FREE_IF_COPY, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, and result.

◆ text_position()

static int text_position ( text t1,
text t2,
Oid  collid 
)
static

Definition at line 916 of file varlena.c.

917{
919 int result;
920
922
923 /* Empty needle always matches at position 1 */
924 if (VARSIZE_ANY_EXHDR(t2) < 1)
925 return 1;
926
927 /* Otherwise, can't match if haystack is shorter than needle */
929 pg_newlocale_from_collation(collid)->deterministic)
930 return 0;
931
933 /* don't need greedy mode here */
934 state.greedy = false;
935
937 result = 0;
938 else
941 return result;
942}
static int text_position_get_match_pos(TextPositionState *state)
Definition varlena.c:1295

References check_collation_set(), collid, fb(), pg_newlocale_from_collation(), result, text_position_cleanup(), text_position_get_match_pos(), text_position_next(), text_position_setup(), and VARSIZE_ANY_EXHDR().

Referenced by textpos().

◆ text_position_cleanup()

static void text_position_cleanup ( TextPositionState state)
static

Definition at line 1319 of file varlena.c.

1320{
1321 /* no cleanup needed */
1322}

Referenced by replace_text(), split_part(), split_text(), and text_position().

◆ text_position_get_match_pos()

static int text_position_get_match_pos ( TextPositionState state)
static

Definition at line 1295 of file varlena.c.

1296{
1297 /* Convert the byte position to char position. */
1298 state->refpos += pg_mbstrlen_with_len(state->refpoint,
1299 state->last_match - state->refpoint);
1300 state->refpoint = state->last_match;
1301 return state->refpos + 1;
1302}

References pg_mbstrlen_with_len().

Referenced by text_position().

◆ text_position_get_match_ptr()

static char * text_position_get_match_ptr ( TextPositionState state)
static

Definition at line 1284 of file varlena.c.

1285{
1286 return state->last_match;
1287}

Referenced by replace_text(), split_part(), and split_text().

◆ text_position_next()

static bool text_position_next ( TextPositionState state)
static

Definition at line 1083 of file varlena.c.

1084{
1085 int needle_len = state->len2;
1086 char *start_ptr;
1087 char *matchptr;
1088
1089 if (needle_len <= 0)
1090 return false; /* result for empty pattern */
1091
1092 /* Start from the point right after the previous match. */
1093 if (state->last_match)
1094 start_ptr = state->last_match + state->last_match_len;
1095 else
1096 start_ptr = state->str1;
1097
1098retry:
1100
1101 if (!matchptr)
1102 return false;
1103
1104 /*
1105 * Found a match for the byte sequence. If this is a multibyte encoding,
1106 * where one character's byte sequence can appear inside a longer
1107 * multi-byte character, we need to verify that the match was at a
1108 * character boundary, not in the middle of a multi-byte character.
1109 */
1110 if (state->is_multibyte_char_in_char && state->locale->deterministic)
1111 {
1112 const char *haystack_end = state->str1 + state->len1;
1113
1114 /* Walk one character at a time, until we reach the match. */
1115
1116 /* the search should never move backwards. */
1117 Assert(state->refpoint <= matchptr);
1118
1119 while (state->refpoint < matchptr)
1120 {
1121 /* step to next character. */
1122 state->refpoint += pg_mblen_range(state->refpoint, haystack_end);
1123 state->refpos++;
1124
1125 /*
1126 * If we stepped over the match's start position, then it was a
1127 * false positive, where the byte sequence appeared in the middle
1128 * of a multi-byte character. Skip it, and continue the search at
1129 * the next character boundary.
1130 */
1131 if (state->refpoint > matchptr)
1132 {
1133 start_ptr = state->refpoint;
1134 goto retry;
1135 }
1136 }
1137 }
1138
1139 state->last_match = matchptr;
1140 state->last_match_len = state->last_match_len_tmp;
1141 return true;
1142}
static char * text_position_next_internal(char *start_ptr, TextPositionState *state)
Definition varlena.c:1150

References Assert, fb(), pg_mblen_range(), and text_position_next_internal().

Referenced by replace_text(), split_part(), split_text(), and text_position().

◆ text_position_next_internal()

static char * text_position_next_internal ( char start_ptr,
TextPositionState state 
)
static

Definition at line 1150 of file varlena.c.

1151{
1152 int haystack_len = state->len1;
1153 int needle_len = state->len2;
1154 int skiptablemask = state->skiptablemask;
1155 const char *haystack = state->str1;
1156 const char *needle = state->str2;
1157 const char *haystack_end = &haystack[haystack_len];
1158 const char *hptr;
1159
1161 Assert(needle_len > 0);
1162
1163 state->last_match_len_tmp = needle_len;
1164
1165 if (!state->locale->deterministic)
1166 {
1167 /*
1168 * With a nondeterministic collation, we have to use an unoptimized
1169 * route. We walk through the haystack and see if at each position
1170 * there is a substring of the remaining string that is equal to the
1171 * needle under the given collation.
1172 *
1173 * Note, the found substring could have a different length than the
1174 * needle. Callers that want to skip over the found string need to
1175 * read the length of the found substring from last_match_len rather
1176 * than just using the length of their needle.
1177 *
1178 * Most callers will require "greedy" semantics, meaning that we need
1179 * to find the longest such substring, not the shortest. For callers
1180 * that don't need greedy semantics, we can finish on the first match.
1181 *
1182 * This loop depends on the assumption that the needle is nonempty and
1183 * any matching substring must also be nonempty. (Even if the
1184 * collation would accept an empty match, returning one would send
1185 * callers that search for successive matches into an infinite loop.)
1186 */
1187 const char *result_hptr = NULL;
1188
1189 hptr = start_ptr;
1190 while (hptr < haystack_end)
1191 {
1192 const char *test_end;
1193
1194 /*
1195 * First check the common case that there is a match in the
1196 * haystack of exactly the length of the needle.
1197 */
1198 if (!state->greedy &&
1201 return (char *) hptr;
1202
1203 /*
1204 * Else check if any of the non-empty substrings starting at hptr
1205 * compare equal to the needle.
1206 */
1207 test_end = hptr;
1208 do
1209 {
1211 if (pg_strncoll(hptr, (test_end - hptr), needle, needle_len, state->locale) == 0)
1212 {
1213 state->last_match_len_tmp = (test_end - hptr);
1214 result_hptr = hptr;
1215 if (!state->greedy)
1216 break;
1217 }
1218 } while (test_end < haystack_end);
1219
1220 if (result_hptr)
1221 break;
1222
1224 }
1225
1226 return (char *) result_hptr;
1227 }
1228 else if (needle_len == 1)
1229 {
1230 /* No point in using B-M-H for a one-character needle */
1231 char nchar = *needle;
1232
1233 hptr = start_ptr;
1234 while (hptr < haystack_end)
1235 {
1236 if (*hptr == nchar)
1237 return (char *) hptr;
1238 hptr++;
1239 }
1240 }
1241 else
1242 {
1243 const char *needle_last = &needle[needle_len - 1];
1244
1245 /* Start at startpos plus the length of the needle */
1246 hptr = start_ptr + needle_len - 1;
1247 while (hptr < haystack_end)
1248 {
1249 /* Match the needle scanning *backward* */
1250 const char *nptr;
1251 const char *p;
1252
1253 nptr = needle_last;
1254 p = hptr;
1255 while (*nptr == *p)
1256 {
1257 /* Matched it all? If so, return 1-based position */
1258 if (nptr == needle)
1259 return (char *) p;
1260 nptr--, p--;
1261 }
1262
1263 /*
1264 * No match, so use the haystack char at hptr to decide how far to
1265 * advance. If the needle had any occurrence of that character
1266 * (or more precisely, one sharing the same skiptable entry)
1267 * before its last character, then we advance far enough to align
1268 * the last such needle character with that haystack position.
1269 * Otherwise we can advance by the whole needle length.
1270 */
1271 hptr += state->skiptable[(unsigned char) *hptr & skiptablemask];
1272 }
1273 }
1274
1275 return 0; /* not found */
1276}
int pg_strncoll(const char *arg1, ssize_t len1, const char *arg2, ssize_t len2, pg_locale_t locale)
Definition pg_locale.c:1404

References Assert, fb(), pg_mblen_range(), and pg_strncoll().

Referenced by text_position_next().

◆ text_position_reset()

static void text_position_reset ( TextPositionState state)
static

Definition at line 1311 of file varlena.c.

1312{
1313 state->last_match = NULL;
1314 state->refpoint = state->str1;
1315 state->refpos = 0;
1316}

References fb().

Referenced by split_part().

◆ text_position_setup()

static void text_position_setup ( text t1,
text t2,
Oid  collid,
TextPositionState state 
)
static

Definition at line 962 of file varlena.c.

963{
964 int len1 = VARSIZE_ANY_EXHDR(t1);
965 int len2 = VARSIZE_ANY_EXHDR(t2);
966
968
970
971 /*
972 * Most callers need greedy mode, but some might want to unset this to
973 * optimize.
974 */
975 state->greedy = true;
976
977 Assert(len2 > 0);
978
979 /*
980 * Even with a multi-byte encoding, we perform the search using the raw
981 * byte sequence, ignoring multibyte issues. For UTF-8, that works fine,
982 * because in UTF-8 the byte sequence of one character cannot contain
983 * another character. For other multi-byte encodings, we do the search
984 * initially as a simple byte search, ignoring multibyte issues, but
985 * verify afterwards that the match we found is at a character boundary,
986 * and continue the search if it was a false match.
987 */
989 state->is_multibyte_char_in_char = false;
990 else if (GetDatabaseEncoding() == PG_UTF8)
991 state->is_multibyte_char_in_char = false;
992 else
993 state->is_multibyte_char_in_char = true;
994
995 state->str1 = VARDATA_ANY(t1);
996 state->str2 = VARDATA_ANY(t2);
997 state->len1 = len1;
998 state->len2 = len2;
999 state->last_match = NULL;
1000 state->refpoint = state->str1;
1001 state->refpos = 0;
1002
1003 /*
1004 * Prepare the skip table for Boyer-Moore-Horspool searching. In these
1005 * notes we use the terminology that the "haystack" is the string to be
1006 * searched (t1) and the "needle" is the pattern being sought (t2).
1007 *
1008 * If the needle is empty or bigger than the haystack then there is no
1009 * point in wasting cycles initializing the table. We also choose not to
1010 * use B-M-H for needles of length 1, since the skip table can't possibly
1011 * save anything in that case.
1012 *
1013 * (With nondeterministic collations, the search is already
1014 * multibyte-aware, so we don't need this.)
1015 */
1016 if (len1 >= len2 && len2 > 1 && state->locale->deterministic)
1017 {
1018 int searchlength = len1 - len2;
1019 int skiptablemask;
1020 int last;
1021 int i;
1022 const char *str2 = state->str2;
1023
1024 /*
1025 * First we must determine how much of the skip table to use. The
1026 * declaration of TextPositionState allows up to 256 elements, but for
1027 * short search problems we don't really want to have to initialize so
1028 * many elements --- it would take too long in comparison to the
1029 * actual search time. So we choose a useful skip table size based on
1030 * the haystack length minus the needle length. The closer the needle
1031 * length is to the haystack length the less useful skipping becomes.
1032 *
1033 * Note: since we use bit-masking to select table elements, the skip
1034 * table size MUST be a power of 2, and so the mask must be 2^N-1.
1035 */
1036 if (searchlength < 16)
1037 skiptablemask = 3;
1038 else if (searchlength < 64)
1039 skiptablemask = 7;
1040 else if (searchlength < 128)
1041 skiptablemask = 15;
1042 else if (searchlength < 512)
1043 skiptablemask = 31;
1044 else if (searchlength < 2048)
1045 skiptablemask = 63;
1046 else if (searchlength < 4096)
1047 skiptablemask = 127;
1048 else
1049 skiptablemask = 255;
1050 state->skiptablemask = skiptablemask;
1051
1052 /*
1053 * Initialize the skip table. We set all elements to the needle
1054 * length, since this is the correct skip distance for any character
1055 * not found in the needle.
1056 */
1057 for (i = 0; i <= skiptablemask; i++)
1058 state->skiptable[i] = len2;
1059
1060 /*
1061 * Now examine the needle. For each character except the last one,
1062 * set the corresponding table element to the appropriate skip
1063 * distance. Note that when two characters share the same skip table
1064 * entry, the one later in the needle must determine the skip
1065 * distance.
1066 */
1067 last = len2 - 1;
1068
1069 for (i = 0; i < last; i++)
1070 state->skiptable[(unsigned char) str2[i] & skiptablemask] = last - i;
1071 }
1072}
#define PG_UTF8
Definition mbprint.c:43
int GetDatabaseEncoding(void)
Definition mbutils.c:1388

References Assert, check_collation_set(), collid, fb(), GetDatabaseEncoding(), i, pg_database_encoding_max_length(), pg_newlocale_from_collation(), PG_UTF8, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

Referenced by replace_text(), split_part(), split_text(), and text_position().

◆ text_reverse()

Datum text_reverse ( PG_FUNCTION_ARGS  )

Definition at line 4726 of file varlena.c.

4727{
4729 const char *p = VARDATA_ANY(str);
4730 int len = VARSIZE_ANY_EXHDR(str);
4731 const char *endp = p + len;
4732 text *result;
4733 char *dst;
4734
4736 dst = (char *) VARDATA(result) + len;
4738
4740 {
4741 /* multibyte version */
4742 while (p < endp)
4743 {
4744 int sz;
4745
4746 sz = pg_mblen_range(p, endp);
4747 dst -= sz;
4748 memcpy(dst, p, sz);
4749 p += sz;
4750 }
4751 }
4752 else
4753 {
4754 /* single byte version */
4755 while (p < endp)
4756 *(--dst) = *p++;
4757 }
4758
4760}

References fb(), len, memcpy(), palloc(), pg_database_encoding_max_length(), PG_GETARG_TEXT_PP, pg_mblen_range(), PG_RETURN_TEXT_P, result, SET_VARSIZE(), str, VARDATA(), VARDATA_ANY(), VARHDRSZ, and VARSIZE_ANY_EXHDR().

◆ text_right()

Datum text_right ( PG_FUNCTION_ARGS  )

Definition at line 4705 of file varlena.c.

4706{
4708 const char *p = VARDATA_ANY(str);
4709 int len = VARSIZE_ANY_EXHDR(str);
4710 int n = PG_GETARG_INT32(1);
4711 int off;
4712
4713 if (n < 0)
4714 n = -n;
4715 else
4716 n = pg_mbstrlen_with_len(p, len) - n;
4717 off = pg_mbcharcliplen(p, len, n);
4718
4720}

References cstring_to_text_with_len(), len, PG_GETARG_INT32, PG_GETARG_TEXT_PP, pg_mbcharcliplen(), pg_mbstrlen_with_len(), PG_RETURN_TEXT_P, str, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

◆ text_smaller()

Datum text_smaller ( PG_FUNCTION_ARGS  )

Definition at line 2343 of file varlena.c.

2344{
2347 text *result;
2348
2349 result = ((text_cmp(arg1, arg2, PG_GET_COLLATION()) < 0) ? arg1 : arg2);
2350
2352}

References fb(), PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_TEXT_P, result, and text_cmp().

◆ text_starts_with()

Datum text_starts_with ( PG_FUNCTION_ARGS  )

Definition at line 1592 of file varlena.c.

1593{
1598 bool result;
1599 Size len1,
1600 len2;
1601
1603
1605
1606 if (!mylocale->deterministic)
1607 ereport(ERROR,
1609 errmsg("nondeterministic collations are not supported for substring searches")));
1610
1611 len1 = toast_raw_datum_size(arg1);
1612 len2 = toast_raw_datum_size(arg2);
1613 if (len2 > len1)
1614 result = false;
1615 else
1616 {
1617 text *targ1 = text_substring(arg1, 1, len2, false);
1619
1621 VARSIZE_ANY_EXHDR(targ2)) == 0);
1622
1625 }
1626
1628}
size_t Size
Definition c.h:689

References check_collation_set(), collid, DatumGetTextPP, ereport, errcode(), errmsg, ERROR, fb(), PG_FREE_IF_COPY, PG_GET_COLLATION, PG_GETARG_DATUM, pg_newlocale_from_collation(), PG_RETURN_BOOL, result, text_substring(), toast_raw_datum_size(), VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

Referenced by spg_text_leaf_consistent(), and t_starts_with().

◆ text_substr()

◆ text_substr_no_len()

Datum text_substr_no_len ( PG_FUNCTION_ARGS  )

Definition at line 567 of file varlena.c.

568{
571 -1, true));
572}

References PG_GETARG_DATUM, PG_GETARG_INT32, PG_RETURN_TEXT_P, and text_substring().

◆ text_substring()

static text * text_substring ( Datum  str,
int32  start,
int32  length,
bool  length_not_specified 
)
static

Definition at line 586 of file varlena.c.

587{
589 int32 S = start; /* start position */
590 int32 S1; /* adjusted start position */
591 int32 L1; /* adjusted substring length */
592 int32 E; /* end position, exclusive */
593
594 /*
595 * SQL99 says S can be zero or negative (which we don't document), but we
596 * still must fetch from the start of the string.
597 * https://www.postgresql.org/message-id/170905442373.643.11536838320909376197%40wrigleys.postgresql.org
598 */
599 S1 = Max(S, 1);
600
601 /* life is easy if the encoding max length is 1 */
602 if (eml == 1)
603 {
604 if (length_not_specified) /* special case - get length to end of
605 * string */
606 L1 = -1;
607 else if (length < 0)
608 {
609 /* SQL99 says to throw an error for E < S, i.e., negative length */
612 errmsg("negative substring length not allowed")));
613 L1 = -1; /* silence stupider compilers */
614 }
615 else if (pg_add_s32_overflow(S, length, &E))
616 {
617 /*
618 * L could be large enough for S + L to overflow, in which case
619 * the substring must run to end of string.
620 */
621 L1 = -1;
622 }
623 else
624 {
625 /*
626 * A zero or negative value for the end position can happen if the
627 * start was negative or one. SQL99 says to return a zero-length
628 * string.
629 */
630 if (E < 1)
631 return cstring_to_text("");
632
633 L1 = E - S1;
634 }
635
636 /*
637 * If the start position is past the end of the string, SQL99 says to
638 * return a zero-length string -- DatumGetTextPSlice() will do that
639 * for us. We need only convert S1 to zero-based starting position.
640 */
641 return DatumGetTextPSlice(str, S1 - 1, L1);
642 }
643 else if (eml > 1)
644 {
645 /*
646 * When encoding max length is > 1, we can't get LC without
647 * detoasting, so we'll grab a conservatively large slice now and go
648 * back later to do the right thing
649 */
653 int32 slice_len;
654 text *slice;
655 int32 E1;
656 int32 i;
657 char *p;
658 char *s;
659 text *ret;
660
661 /*
662 * We need to start at position zero because there is no way to know
663 * in advance which byte offset corresponds to the supplied start
664 * position.
665 */
666 slice_start = 0;
667
668 if (length_not_specified) /* special case - get length to end of
669 * string */
670 E = slice_size = L1 = -1;
671 else if (length < 0)
672 {
673 /* SQL99 says to throw an error for E < S, i.e., negative length */
676 errmsg("negative substring length not allowed")));
677 E = slice_size = L1 = -1; /* silence stupider compilers */
678 }
679 else if (pg_add_s32_overflow(S, length, &E))
680 {
681 /*
682 * L could be large enough for S + L to overflow, in which case
683 * the substring must run to end of string.
684 */
685 slice_size = L1 = -1;
686 }
687 else
688 {
689 /*
690 * Ending at position 1, exclusive, obviously yields an empty
691 * string. A zero or negative value can happen if the start was
692 * negative or one. SQL99 says to return a zero-length string.
693 */
694 if (E <= 1)
695 return cstring_to_text("");
696
697 /*
698 * if E is past the end of the string, the tuple toaster will
699 * truncate the length for us
700 */
701 L1 = E - S1;
702
703 /*
704 * Total slice size in bytes can't be any longer than the
705 * inclusive end position times the encoding max length. If that
706 * overflows, we can just use -1.
707 */
708 if (pg_mul_s32_overflow(E - 1, eml, &slice_size))
709 slice_size = -1;
710 }
711
712 /*
713 * If we're working with an untoasted source, no need to do an extra
714 * copying step.
715 */
719 else
720 slice = (text *) DatumGetPointer(str);
721
722 /* see if we got back an empty string */
723 slice_len = VARSIZE_ANY_EXHDR(slice);
724 if (slice_len == 0)
725 {
726 if (slice != (text *) DatumGetPointer(str))
727 pfree(slice);
728 return cstring_to_text("");
729 }
730
731 /*
732 * Now we can get the actual length of the slice in MB characters,
733 * stopping at the end of the substring. Continuing beyond the
734 * substring end could find an incomplete character attributable
735 * solely to DatumGetTextPSlice() chopping in the middle of a
736 * character, and it would be superfluous work at best.
737 */
739 (slice_size == -1 ?
740 pg_mbstrlen_with_len(VARDATA_ANY(slice), slice_len) :
741 pg_mbcharcliplen_chars(VARDATA_ANY(slice), slice_len, E - 1));
742
743 /*
744 * Check that the start position wasn't > slice_strlen. If so, SQL99
745 * says to return a zero-length string.
746 */
747 if (S1 > slice_strlen)
748 {
749 if (slice != (text *) DatumGetPointer(str))
750 pfree(slice);
751 return cstring_to_text("");
752 }
753
754 /*
755 * Adjust L1 and E1 now that we know the slice string length. Again
756 * remember that S1 is one based, and slice_start is zero based.
757 */
758 if (L1 > -1)
759 E1 = Min(S1 + L1, slice_start + 1 + slice_strlen);
760 else
762
763 /*
764 * Find the start position in the slice; remember S1 is not zero based
765 */
766 p = VARDATA_ANY(slice);
767 for (i = 0; i < S1 - 1; i++)
768 p += pg_mblen_unbounded(p);
769
770 /* hang onto a pointer to our start position */
771 s = p;
772
773 /*
774 * Count the actual bytes used by the substring of the requested
775 * length.
776 */
777 for (i = S1; i < E1; i++)
778 p += pg_mblen_unbounded(p);
779
780 ret = (text *) palloc(VARHDRSZ + (p - s));
781 SET_VARSIZE(ret, VARHDRSZ + (p - s));
782 memcpy(VARDATA(ret), s, (p - s));
783
784 if (slice != (text *) DatumGetPointer(str))
785 pfree(slice);
786
787 return ret;
788 }
789 else
790 elog(ERROR, "invalid backend encoding: encoding max length < 1");
791
792 /* not reached: suppress compiler warning */
793 return NULL;
794}
#define Max(x, y)
Definition c.h:1085
#define DatumGetTextPSlice(X, m, n)
Definition fmgr.h:305
return str start
#define S(n, x)
Definition sha1.c:73
static bool VARATT_IS_EXTERNAL(const void *PTR)
Definition varatt.h:354
static bool VARATT_IS_COMPRESSED(const void *PTR)
Definition varatt.h:347
static int pg_mbcharcliplen_chars(const char *mbstr, int len, int limit)
Definition varlena.c:804

References cstring_to_text(), DatumGetPointer(), DatumGetTextPSlice, elog, ereport, errcode(), errmsg, ERROR, fb(), i, Max, memcpy(), Min, palloc(), pfree(), pg_add_s32_overflow(), pg_database_encoding_max_length(), pg_mbcharcliplen_chars(), pg_mblen_unbounded(), pg_mbstrlen_with_len(), pg_mul_s32_overflow(), S, SET_VARSIZE(), start, str, VARATT_IS_COMPRESSED(), VARATT_IS_EXTERNAL(), VARDATA(), VARDATA_ANY(), VARHDRSZ, and VARSIZE_ANY_EXHDR().

Referenced by text_left(), text_overlay(), text_starts_with(), text_substr(), and text_substr_no_len().

◆ text_to_array()

Datum text_to_array ( PG_FUNCTION_ARGS  )

Definition at line 3652 of file varlena.c.

3653{
3655
3656 /* For array output, tstate should start as all zeroes */
3657 memset(&tstate, 0, sizeof(tstate));
3658
3659 if (!split_text(fcinfo, &tstate))
3661
3662 if (tstate.astate == NULL)
3664
3667}
#define PG_RETURN_ARRAYTYPE_P(x)
Definition array.h:265
ArrayType * construct_empty_array(Oid elmtype)
Datum makeArrayResult(ArrayBuildState *astate, MemoryContext rcontext)
#define PG_RETURN_DATUM(x)
Definition fmgr.h:354
static bool split_text(FunctionCallInfo fcinfo, SplitTextOutputData *tstate)
Definition varlena.c:3729

References construct_empty_array(), CurrentMemoryContext, fb(), makeArrayResult(), PG_RETURN_ARRAYTYPE_P, PG_RETURN_DATUM, PG_RETURN_NULL, and split_text().

Referenced by text_to_array_null().

◆ text_to_array_null()

Datum text_to_array_null ( PG_FUNCTION_ARGS  )

Definition at line 3678 of file varlena.c.

3679{
3680 return text_to_array(fcinfo);
3681}
Datum text_to_array(PG_FUNCTION_ARGS)
Definition varlena.c:3652

References text_to_array().

◆ text_to_cstring()

char * text_to_cstring ( const text t)

Definition at line 217 of file varlena.c.

218{
219 /* must cast away the const, unfortunately */
222 char *result;
223
224 result = (char *) palloc(len + 1);
226 result[len] = '\0';
227
228 if (tunpacked != t)
230
231 return result;
232}
#define unconstify(underlying_type, expr)
Definition c.h:1325
varlena * pg_detoast_datum_packed(varlena *datum)
Definition fmgr.c:1830

References fb(), len, memcpy(), palloc(), pfree(), pg_detoast_datum_packed(), result, unconstify, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

Referenced by array_to_text(), array_to_text_null(), binary_upgrade_add_sub_rel_state(), binary_upgrade_create_empty_extension(), binary_upgrade_replorigin_advance(), binary_upgrade_set_missing_value(), connectby_text(), connectby_text_serial(), convert_and_check_filename(), convert_any_priv_string(), convert_column_name(), convert_database_name(), convert_foreign_data_wrapper_name(), convert_function_name(), convert_language_name(), convert_schema_name(), convert_server_name(), convert_tablespace_name(), convert_type_name(), crosstab(), crosstab_hash(), cursor_to_xml(), cursor_to_xmlschema(), daitch_mokotoff(), database_to_xml(), database_to_xml_and_xmlschema(), database_to_xmlschema(), datetime_to_char_body(), dblink_cancel_query(), dblink_close(), dblink_connect(), dblink_disconnect(), dblink_error_message(), dblink_exec(), dblink_fetch(), dblink_get_notify(), dblink_is_busy(), dblink_open(), dblink_record_internal(), dblink_send_query(), deserialize_deflist(), difference(), dmetaphone(), dmetaphone_alt(), do_to_timestamp(), errno_from_string(), ExecAlterExtensionStmt(), execute_extension_script(), executeDateTimeMethod(), ForeignServerConnectionString(), get_raw_page_fork(), get_raw_page_fork_1_9(), has_param_priv_byname(), has_sequence_privilege_id_name(), has_sequence_privilege_name(), has_sequence_privilege_name_name(), injection_points_attach(), injection_points_attach_func(), injection_points_cached(), injection_points_detach(), injection_points_load(), injection_points_run(), injection_points_wakeup(), json_object_field(), json_object_field_text(), jsonb_set_lax(), JsonItemFromDatum(), ltree_addtext(), ltree_textadd(), NUM_cache(), parse_datetime(), parse_ident(), pg_backup_start(), pg_create_advice_stash(), pg_create_restore_point(), pg_crypt(), pg_current_logfile(), pg_drop_advice_stash(), pg_get_advice_stash_contents(), pg_get_expr_worker(), pg_get_logical_snapshot_info(), pg_get_logical_snapshot_meta(), pg_get_publication_sequences(), pg_get_serial_sequence(), pg_index_column_has_property(), pg_index_has_property(), pg_indexam_has_property(), pg_input_is_valid_common(), pg_logical_emit_message_bytea(), pg_ls_replslotdir(), pg_notify(), pg_prewarm(), pg_relation_size(), pg_replication_origin_advance(), pg_replication_origin_create(), pg_replication_origin_drop(), pg_replication_origin_oid(), pg_replication_origin_progress(), pg_replication_origin_session_setup(), pg_set_stashed_advice(), pg_size_bytes(), pg_split_walfile_name(), pg_stat_get_progress_info(), pg_stat_get_replication_slot(), pg_stat_have_stats(), pg_stat_reset_replication_slot(), pg_stat_reset_shared(), pg_stat_reset_slru(), pgxml_texttoxmlchar(), phraseto_tsquery_byid(), plainto_tsquery_byid(), postgres_fdw_disconnect(), query_to_xml(), query_to_xml_and_xmlschema(), query_to_xmlschema(), quote_ident(), quote_ident_cstr(), range_constructor3(), regress_setenv(), replorigin_by_oid(), schema_to_xml(), schema_to_xml_and_xmlschema(), schema_to_xmlschema(), sepgsql_mcstrans_in(), sepgsql_mcstrans_out(), soundex(), table_to_xml(), table_to_xml_and_xmlschema(), table_to_xmlschema(), test_canonicalize_path(), test_custom_stats_var_create(), test_custom_stats_var_drop(), test_custom_stats_var_report(), test_custom_stats_var_update(), test_mblen_func(), test_predtest(), test_slru_page_write(), test_text_to_wchars(), test_valid_server_encoding(), test_wchars_to_text(), text2ltree(), text_concat_ws(), textToQualifiedNameList(), to_date(), to_regclass(), to_regcollation(), to_regdatabase(), to_regnamespace(), to_regoper(), to_regoperator(), to_regproc(), to_regprocedure(), to_regrole(), to_regtype(), to_regtypemod(), to_tsquery_byid(), ts_stat_sql(), tsquery_rewrite_query(), tuple_data_split(), unicode_is_normalized(), unicode_normalize_func(), verify_heapam(), websearch_to_tsquery_byid(), X509_NAME_field_to_text(), xml_out_internal(), xmlconcat(), xmlpi(), xmlroot(), and xpath_table().

◆ text_to_cstring_buffer()

void text_to_cstring_buffer ( const text src,
char dst,
size_t  dst_len 
)

Definition at line 248 of file varlena.c.

249{
250 /* must cast away the const, unfortunately */
253
254 if (dst_len > 0)
255 {
256 dst_len--;
257 if (dst_len >= src_len)
259 else /* ensure truncation is encoding-safe */
262 dst[dst_len] = '\0';
263 }
264
265 if (srcunpacked != src)
267}

References fb(), memcpy(), pfree(), pg_detoast_datum_packed(), pg_mbcliplen(), unconstify, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

Referenced by be_lo_export(), lo_import_internal(), lookup_timezone(), parse_sane_timezone(), pg_gen_salt(), pg_gen_salt_rounds(), timestamp_zone(), timestamptz_zone(), and timetz_zone().

◆ text_to_table()

Datum text_to_table ( PG_FUNCTION_ARGS  )

Definition at line 3689 of file varlena.c.

3690{
3691 ReturnSetInfo *rsi = (ReturnSetInfo *) fcinfo->resultinfo;
3693
3694 tstate.astate = NULL;
3696 tstate.tupstore = rsi->setResult;
3697 tstate.tupdesc = rsi->setDesc;
3698
3699 (void) split_text(fcinfo, &tstate);
3700
3701 return (Datum) 0;
3702}
void InitMaterializedSRF(FunctionCallInfo fcinfo, uint32 flags)
Definition funcapi.c:76
#define MAT_SRF_USE_EXPECTED_DESC
Definition funcapi.h:296
ArrayBuildState * astate
Definition varlena.c:110

References SplitTextOutputData::astate, fb(), InitMaterializedSRF(), MAT_SRF_USE_EXPECTED_DESC, ReturnSetInfo::setDesc, ReturnSetInfo::setResult, and split_text().

Referenced by text_to_table_null().

◆ text_to_table_null()

Datum text_to_table_null ( PG_FUNCTION_ARGS  )

Definition at line 3713 of file varlena.c.

3714{
3715 return text_to_table(fcinfo);
3716}
Datum text_to_table(PG_FUNCTION_ARGS)
Definition varlena.c:3689

References text_to_table().

◆ textcat()

Datum textcat ( PG_FUNCTION_ARGS  )

Definition at line 448 of file varlena.c.

449{
452
454}

References fb(), PG_GETARG_TEXT_PP, PG_RETURN_TEXT_P, and text_catenate().

◆ texteq()

Datum texteq ( PG_FUNCTION_ARGS  )

Definition at line 1428 of file varlena.c.

1429{
1432 bool result;
1433
1435
1437
1438 if (mylocale->deterministic)
1439 {
1442 Size len1,
1443 len2;
1444
1445 /*
1446 * Since we only care about equality or not-equality, we can avoid all
1447 * the expense of strcoll() here, and just do bitwise comparison. In
1448 * fact, we don't even have to do a bitwise comparison if we can show
1449 * the lengths of the strings are unequal; which might save us from
1450 * having to detoast one or both values.
1451 */
1452 len1 = toast_raw_datum_size(arg1);
1453 len2 = toast_raw_datum_size(arg2);
1454 if (len1 != len2)
1455 result = false;
1456 else
1457 {
1460
1462 len1 - VARHDRSZ) == 0);
1463
1466 }
1467 }
1468 else
1469 {
1472
1473 result = (text_cmp(arg1, arg2, collid) == 0);
1474
1477 }
1478
1480}

References check_collation_set(), collid, DatumGetTextPP, fb(), PG_FREE_IF_COPY, PG_GET_COLLATION, PG_GETARG_DATUM, PG_GETARG_TEXT_PP, pg_newlocale_from_collation(), PG_RETURN_BOOL, result, text_cmp(), toast_raw_datum_size(), VARDATA_ANY(), and VARHDRSZ.

Referenced by gbt_texteq(), text_isequal(), and texteqfast().

◆ texteqname()

Datum texteqname ( PG_FUNCTION_ARGS  )

Definition at line 2385 of file varlena.c.

2386{
2389 size_t len1 = VARSIZE_ANY_EXHDR(arg1);
2390 size_t len2 = strlen(NameStr(*arg2));
2392 bool result;
2393
2395
2396 if (collid == C_COLLATION_OID)
2397 result = (len1 == len2 &&
2398 memcmp(VARDATA_ANY(arg1), NameStr(*arg2), len1) == 0);
2399 else
2401 NameStr(*arg2), len2,
2402 collid) == 0);
2403
2405
2407}

References check_collation_set(), collid, fb(), NameStr, PG_FREE_IF_COPY, PG_GET_COLLATION, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, VARDATA_ANY(), VARSIZE_ANY_EXHDR(), and varstr_cmp().

◆ textgename()

Datum textgename ( PG_FUNCTION_ARGS  )

Definition at line 2540 of file varlena.c.

2541{
2543}
Datum bttextnamecmp(PG_FUNCTION_ARGS)
Definition varlena.c:2476

References bttextnamecmp(), CmpCall, and PG_RETURN_BOOL.

◆ textgtname()

Datum textgtname ( PG_FUNCTION_ARGS  )

Definition at line 2534 of file varlena.c.

2535{
2537}

References bttextnamecmp(), CmpCall, and PG_RETURN_BOOL.

◆ textin()

Datum textin ( PG_FUNCTION_ARGS  )

Definition at line 278 of file varlena.c.

279{
280 char *inputText = PG_GETARG_CSTRING(0);
281
283}
#define PG_GETARG_CSTRING(n)
Definition fmgr.h:278

References cstring_to_text(), fb(), PG_GETARG_CSTRING, and PG_RETURN_TEXT_P.

Referenced by ExecEvalJsonExprPath().

◆ textlen()

Datum textlen ( PG_FUNCTION_ARGS  )

Definition at line 392 of file varlena.c.

393{
395
396 /* try to avoid decompressing argument */
398}
static int32 text_length(Datum str)
Definition varlena.c:410

References PG_GETARG_DATUM, PG_RETURN_INT32, str, and text_length().

◆ textlename()

Datum textlename ( PG_FUNCTION_ARGS  )

Definition at line 2528 of file varlena.c.

2529{
2531}

References bttextnamecmp(), CmpCall, and PG_RETURN_BOOL.

◆ textltname()

Datum textltname ( PG_FUNCTION_ARGS  )

Definition at line 2522 of file varlena.c.

2523{
2525}

References bttextnamecmp(), CmpCall, and PG_RETURN_BOOL.

◆ textne()

Datum textne ( PG_FUNCTION_ARGS  )

Definition at line 1483 of file varlena.c.

1484{
1487 bool result;
1488
1490
1492
1493 if (mylocale->deterministic)
1494 {
1497 Size len1,
1498 len2;
1499
1500 /* See comment in texteq() */
1501 len1 = toast_raw_datum_size(arg1);
1502 len2 = toast_raw_datum_size(arg2);
1503 if (len1 != len2)
1504 result = true;
1505 else
1506 {
1509
1511 len1 - VARHDRSZ) != 0);
1512
1515 }
1516 }
1517 else
1518 {
1521
1522 result = (text_cmp(arg1, arg2, collid) != 0);
1523
1526 }
1527
1529}

References check_collation_set(), collid, DatumGetTextPP, fb(), PG_FREE_IF_COPY, PG_GET_COLLATION, PG_GETARG_DATUM, PG_GETARG_TEXT_PP, pg_newlocale_from_collation(), PG_RETURN_BOOL, result, text_cmp(), toast_raw_datum_size(), VARDATA_ANY(), and VARHDRSZ.

◆ textnename()

Datum textnename ( PG_FUNCTION_ARGS  )

Definition at line 2435 of file varlena.c.

2436{
2439 size_t len1 = VARSIZE_ANY_EXHDR(arg1);
2440 size_t len2 = strlen(NameStr(*arg2));
2442 bool result;
2443
2445
2446 if (collid == C_COLLATION_OID)
2447 result = !(len1 == len2 &&
2448 memcmp(VARDATA_ANY(arg1), NameStr(*arg2), len1) == 0);
2449 else
2450 result = !(varstr_cmp(VARDATA_ANY(arg1), len1,
2451 NameStr(*arg2), len2,
2452 collid) == 0);
2453
2455
2457}

References check_collation_set(), collid, fb(), NameStr, PG_FREE_IF_COPY, PG_GET_COLLATION, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, VARDATA_ANY(), VARSIZE_ANY_EXHDR(), and varstr_cmp().

◆ textoctetlen()

Datum textoctetlen ( PG_FUNCTION_ARGS  )

Definition at line 429 of file varlena.c.

430{
432
433 /* We need not detoast the input at all */
435}

References PG_GETARG_DATUM, PG_RETURN_INT32, str, toast_raw_datum_size(), and VARHDRSZ.

◆ textout()

Datum textout ( PG_FUNCTION_ARGS  )

Definition at line 289 of file varlena.c.

290{
292
294}
#define TextDatumGetCString(d)
Definition builtins.h:99
#define PG_RETURN_CSTRING(x)
Definition fmgr.h:364

References fb(), PG_GETARG_DATUM, PG_RETURN_CSTRING, and TextDatumGetCString.

Referenced by pg_node_tree_out(), plsample_func_handler(), and plsample_trigger_handler().

◆ textoverlay()

Datum textoverlay ( PG_FUNCTION_ARGS  )

Definition at line 833 of file varlena.c.

834{
837 int sp = PG_GETARG_INT32(2); /* substring start position */
838 int sl = PG_GETARG_INT32(3); /* substring length */
839
841}
static text * text_overlay(text *t1, text *t2, int sp, int sl)
Definition varlena.c:856

References fb(), PG_GETARG_INT32, PG_GETARG_TEXT_PP, PG_RETURN_TEXT_P, and text_overlay().

◆ textoverlay_no_len()

Datum textoverlay_no_len ( PG_FUNCTION_ARGS  )

Definition at line 844 of file varlena.c.

845{
848 int sp = PG_GETARG_INT32(2); /* substring start position */
849 int sl;
850
851 sl = text_length(PointerGetDatum(t2)); /* defaults to length(t2) */
853}

References fb(), PG_GETARG_INT32, PG_GETARG_TEXT_PP, PG_RETURN_TEXT_P, PointerGetDatum, text_length(), and text_overlay().

◆ textpos()

Datum textpos ( PG_FUNCTION_ARGS  )

Definition at line 893 of file varlena.c.

894{
897
899}
static int text_position(text *t1, text *t2, Oid collid)
Definition varlena.c:916

References fb(), PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_INT32, str, and text_position().

◆ textrecv()

Datum textrecv ( PG_FUNCTION_ARGS  )

Definition at line 300 of file varlena.c.

301{
303 text *result;
304 char *str;
305 int nbytes;
306
307 str = pq_getmsgtext(buf, buf->len - buf->cursor, &nbytes);
308
310 pfree(str);
312}
char * pq_getmsgtext(StringInfo msg, int rawbytes, int *nbytes)
Definition pqformat.c:545

References buf, cstring_to_text_with_len(), pfree(), PG_GETARG_POINTER, PG_RETURN_TEXT_P, pq_getmsgtext(), result, and str.

◆ textsend()

Datum textsend ( PG_FUNCTION_ARGS  )

Definition at line 318 of file varlena.c.

319{
320 text *t = PG_GETARG_TEXT_PP(0);
322
326}
void pq_sendtext(StringInfo buf, const char *str, int slen)
Definition pqformat.c:172

References buf, PG_GETARG_TEXT_PP, PG_RETURN_BYTEA_P, pq_begintypsend(), pq_endtypsend(), pq_sendtext(), VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

Referenced by bpcharsend(), pg_node_tree_send(), and varcharsend().

◆ textToQualifiedNameList()

List * textToQualifiedNameList ( text textval)

Definition at line 2719 of file varlena.c.

2720{
2721 char *rawname;
2722 List *result = NIL;
2723 List *namelist;
2724 ListCell *l;
2725
2726 /* Convert to C string (handles possible detoasting). */
2727 /* Note we rely on being able to modify rawname below. */
2728 rawname = text_to_cstring(textval);
2729
2731 ereport(ERROR,
2733 errmsg("invalid name syntax")));
2734
2735 if (namelist == NIL)
2736 ereport(ERROR,
2738 errmsg("invalid name syntax")));
2739
2740 foreach(l, namelist)
2741 {
2742 char *curname = (char *) lfirst(l);
2743
2745 }
2746
2747 pfree(rawname);
2749
2750 return result;
2751}
void list_free(List *list)
Definition list.c:1546
#define lfirst(lc)
Definition pg_list.h:172
Definition pg_list.h:54
String * makeString(char *str)
Definition value.c:63
bool SplitIdentifierString(char *rawstring, char separator, List **namelist)
Definition varlena.c:2867

References ereport, errcode(), errmsg, ERROR, fb(), lappend(), lfirst, list_free(), makeString(), NIL, pfree(), pstrdup(), result, SplitIdentifierString(), and text_to_cstring().

Referenced by bt_metap(), bt_multi_page_stats(), bt_page_items_internal(), bt_page_stats_internal(), convert_table_name(), currtid_byrelname(), get_raw_page_internal(), get_rel_from_relname(), nextval(), pg_get_serial_sequence(), pg_get_viewdef_name(), pg_get_viewdef_name_ext(), pg_relpages(), pg_relpages_v1_5(), pgrowlocks(), pgstatindex(), pgstatindex_v1_5(), pgstattuple(), pgstattuple_v1_5(), row_security_active_name(), text_regclass(), ts_parse_byname(), and ts_token_type_byname().

◆ to_bin32()

Datum to_bin32 ( PG_FUNCTION_ARGS  )

Definition at line 4099 of file varlena.c.

4100{
4102
4104}
uint32_t uint32
Definition c.h:624
static text * convert_to_base(uint64 value, int base)
Definition varlena.c:4073

References convert_to_base(), PG_GETARG_INT32, PG_RETURN_TEXT_P, and value.

◆ to_bin64()

Datum to_bin64 ( PG_FUNCTION_ARGS  )

Definition at line 4106 of file varlena.c.

4107{
4109
4111}
#define PG_GETARG_INT64(n)
Definition fmgr.h:284

References convert_to_base(), PG_GETARG_INT64, PG_RETURN_TEXT_P, and value.

◆ to_hex32()

Datum to_hex32 ( PG_FUNCTION_ARGS  )

Definition at line 4137 of file varlena.c.

4138{
4140
4142}

References convert_to_base(), PG_GETARG_INT32, PG_RETURN_TEXT_P, and value.

Referenced by gin_page_opaque_info(), and gist_page_opaque_info().

◆ to_hex64()

Datum to_hex64 ( PG_FUNCTION_ARGS  )

Definition at line 4144 of file varlena.c.

4145{
4147
4149}

References convert_to_base(), PG_GETARG_INT64, PG_RETURN_TEXT_P, and value.

◆ to_oct32()

Datum to_oct32 ( PG_FUNCTION_ARGS  )

Definition at line 4118 of file varlena.c.

4119{
4121
4123}

References convert_to_base(), PG_GETARG_INT32, PG_RETURN_TEXT_P, and value.

◆ to_oct64()

Datum to_oct64 ( PG_FUNCTION_ARGS  )

Definition at line 4125 of file varlena.c.

4126{
4128
4130}

References convert_to_base(), PG_GETARG_INT64, PG_RETURN_TEXT_P, and value.

◆ unicode_assigned()

Datum unicode_assigned ( PG_FUNCTION_ARGS  )

Definition at line 5460 of file varlena.c.

5461{
5463 unsigned char *p;
5464 int size;
5465
5467 ereport(ERROR,
5468 (errmsg("Unicode categorization can only be performed if server encoding is UTF8")));
5469
5470 /* convert to char32_t */
5472 p = (unsigned char *) VARDATA_ANY(input);
5473 for (int i = 0; i < size; i++)
5474 {
5475 char32_t uchar = utf8_to_unicode(p);
5476 int category = unicode_category(uchar);
5477
5478 if (category == PG_U_UNASSIGNED)
5479 PG_RETURN_BOOL(false);
5480
5481 p += pg_utf_mblen(p);
5482 }
5483
5484 PG_RETURN_BOOL(true);
5485}
FILE * input
static char32_t utf8_to_unicode(const unsigned char *c)
Definition mbprint.c:53
#define pg_utf_mblen
Definition pg_wchar.h:486
pg_unicode_category unicode_category(char32_t code)
@ PG_U_UNASSIGNED

References ereport, errmsg, ERROR, fb(), GetDatabaseEncoding(), i, input, PG_GETARG_TEXT_PP, pg_mbstrlen_with_len(), PG_RETURN_BOOL, PG_U_UNASSIGNED, PG_UTF8, pg_utf_mblen, unicode_category(), utf8_to_unicode(), VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

◆ unicode_is_normalized()

Datum unicode_is_normalized ( PG_FUNCTION_ARGS  )

Definition at line 5554 of file varlena.c.

5555{
5559 int size;
5560 char32_t *input_chars;
5561 char32_t *output_chars;
5562 unsigned char *p;
5563 int i;
5564 UnicodeNormalizationQC quickcheck;
5565 int output_size;
5566 bool result;
5567
5569
5570 /* convert to char32_t */
5572 input_chars = palloc((size + 1) * sizeof(char32_t));
5573 p = (unsigned char *) VARDATA_ANY(input);
5574 for (i = 0; i < size; i++)
5575 {
5577 p += pg_utf_mblen(p);
5578 }
5579 input_chars[i] = (char32_t) '\0';
5580 Assert((char *) p == VARDATA_ANY(input) + VARSIZE_ANY_EXHDR(input));
5581
5582 /* quick check (see UAX #15) */
5584 if (quickcheck == UNICODE_NORM_QC_YES)
5585 PG_RETURN_BOOL(true);
5586 else if (quickcheck == UNICODE_NORM_QC_NO)
5587 PG_RETURN_BOOL(false);
5588
5589 /* normalize and compare with original */
5591
5592 output_size = 0;
5593 for (char32_t *wp = output_chars; *wp; wp++)
5594 output_size++;
5595
5596 result = (size == output_size) &&
5597 (memcmp(input_chars, output_chars, size * sizeof(char32_t)) == 0);
5598
5600}
uint32_t char32_t
Definition c.h:1504
UnicodeNormalizationQC unicode_is_normalized_quickcheck(UnicodeNormalizationForm form, const char32_t *input)
char32_t * unicode_normalize(UnicodeNormalizationForm form, const char32_t *input)
UnicodeNormalizationForm
UnicodeNormalizationQC
@ UNICODE_NORM_QC_YES
@ UNICODE_NORM_QC_NO
static UnicodeNormalizationForm unicode_norm_form_from_string(const char *formstr)
Definition varlena.c:5399

References Assert, fb(), i, input, palloc(), PG_GETARG_TEXT_PP, pg_mbstrlen_with_len(), PG_RETURN_BOOL, pg_utf_mblen, result, text_to_cstring(), unicode_is_normalized_quickcheck(), unicode_norm_form_from_string(), UNICODE_NORM_QC_NO, UNICODE_NORM_QC_YES, unicode_normalize(), utf8_to_unicode(), VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

◆ unicode_norm_form_from_string()

static UnicodeNormalizationForm unicode_norm_form_from_string ( const char formstr)
static

Definition at line 5399 of file varlena.c.

5400{
5402
5403 /*
5404 * Might as well check this while we're here.
5405 */
5407 ereport(ERROR,
5409 errmsg("Unicode normalization can only be performed if server encoding is UTF8")));
5410
5411 if (pg_strcasecmp(formstr, "NFC") == 0)
5412 form = UNICODE_NFC;
5413 else if (pg_strcasecmp(formstr, "NFD") == 0)
5414 form = UNICODE_NFD;
5415 else if (pg_strcasecmp(formstr, "NFKC") == 0)
5417 else if (pg_strcasecmp(formstr, "NFKD") == 0)
5419 else
5420 ereport(ERROR,
5422 errmsg("invalid normalization form: %s", formstr)));
5423
5424 return form;
5425}
int pg_strcasecmp(const char *s1, const char *s2)
@ UNICODE_NFKD
@ UNICODE_NFD
@ UNICODE_NFC
@ UNICODE_NFKC

References ereport, errcode(), errmsg, ERROR, fb(), GetDatabaseEncoding(), pg_strcasecmp(), PG_UTF8, UNICODE_NFC, UNICODE_NFD, UNICODE_NFKC, and UNICODE_NFKD.

Referenced by unicode_is_normalized(), and unicode_normalize_func().

◆ unicode_normalize_func()

Datum unicode_normalize_func ( PG_FUNCTION_ARGS  )

Definition at line 5488 of file varlena.c.

5489{
5493 int size;
5494 char32_t *input_chars;
5495 char32_t *output_chars;
5496 unsigned char *p;
5497 text *result;
5498 int i;
5499
5501
5502 /* convert to char32_t */
5504 input_chars = palloc((size + 1) * sizeof(char32_t));
5505 p = (unsigned char *) VARDATA_ANY(input);
5506 for (i = 0; i < size; i++)
5507 {
5509 p += pg_utf_mblen(p);
5510 }
5511 input_chars[i] = (char32_t) '\0';
5512 Assert((char *) p == VARDATA_ANY(input) + VARSIZE_ANY_EXHDR(input));
5513
5514 /* action */
5516
5517 /* convert back to UTF-8 string */
5518 size = 0;
5519 for (char32_t *wp = output_chars; *wp; wp++)
5520 {
5521 unsigned char buf[4];
5522
5524 size += pg_utf_mblen(buf);
5525 }
5526
5527 result = palloc(size + VARHDRSZ);
5528 SET_VARSIZE(result, size + VARHDRSZ);
5529
5530 p = (unsigned char *) VARDATA_ANY(result);
5531 for (char32_t *wp = output_chars; *wp; wp++)
5532 {
5533 unicode_to_utf8(*wp, p);
5534 p += pg_utf_mblen(p);
5535 }
5536 Assert((char *) p == (char *) result + size + VARHDRSZ);
5537
5539}
static unsigned char * unicode_to_utf8(char32_t c, unsigned char *utf8string)
Definition pg_wchar.h:428

References Assert, buf, fb(), i, input, palloc(), PG_GETARG_TEXT_PP, pg_mbstrlen_with_len(), PG_RETURN_TEXT_P, pg_utf_mblen, result, SET_VARSIZE(), text_to_cstring(), unicode_norm_form_from_string(), unicode_normalize(), unicode_to_utf8(), utf8_to_unicode(), VARDATA_ANY(), VARHDRSZ, and VARSIZE_ANY_EXHDR().

◆ unicode_version()

Datum unicode_version ( PG_FUNCTION_ARGS  )

Definition at line 5436 of file varlena.c.

5437{
5439}
#define PG_UNICODE_VERSION

References cstring_to_text(), PG_RETURN_TEXT_P, and PG_UNICODE_VERSION.

◆ unistr()

Datum unistr ( PG_FUNCTION_ARGS  )

Definition at line 5646 of file varlena.c.

5647{
5649 char *instr;
5650 int len;
5652 text *result;
5653 char16_t pair_first = 0;
5655
5656 instr = VARDATA_ANY(input_text);
5658
5660
5661 while (len > 0)
5662 {
5663 if (instr[0] == '\\')
5664 {
5665 if (len >= 2 &&
5666 instr[1] == '\\')
5667 {
5668 if (pair_first)
5669 goto invalid_pair;
5670 appendStringInfoChar(&str, '\\');
5671 instr += 2;
5672 len -= 2;
5673 }
5674 else if ((len >= 5 && isxdigits_n(instr + 1, 4)) ||
5675 (len >= 6 && instr[1] == 'u' && isxdigits_n(instr + 2, 4)))
5676 {
5677 char32_t unicode;
5678 int offset = instr[1] == 'u' ? 2 : 1;
5679
5680 unicode = hexval_n(instr + offset, 4);
5681
5683 ereport(ERROR,
5685 errmsg("invalid Unicode code point: %04X", unicode));
5686
5687 if (pair_first)
5688 {
5690 {
5692 pair_first = 0;
5693 }
5694 else
5695 goto invalid_pair;
5696 }
5698 goto invalid_pair;
5699
5702 else
5703 {
5704 pg_unicode_to_server(unicode, (unsigned char *) cbuf);
5706 }
5707
5708 instr += 4 + offset;
5709 len -= 4 + offset;
5710 }
5711 else if (len >= 8 && instr[1] == '+' && isxdigits_n(instr + 2, 6))
5712 {
5713 char32_t unicode;
5714
5715 unicode = hexval_n(instr + 2, 6);
5716
5718 ereport(ERROR,
5720 errmsg("invalid Unicode code point: %04X", unicode));
5721
5722 if (pair_first)
5723 {
5725 {
5727 pair_first = 0;
5728 }
5729 else
5730 goto invalid_pair;
5731 }
5733 goto invalid_pair;
5734
5737 else
5738 {
5739 pg_unicode_to_server(unicode, (unsigned char *) cbuf);
5741 }
5742
5743 instr += 8;
5744 len -= 8;
5745 }
5746 else if (len >= 10 && instr[1] == 'U' && isxdigits_n(instr + 2, 8))
5747 {
5748 char32_t unicode;
5749
5750 unicode = hexval_n(instr + 2, 8);
5751
5753 ereport(ERROR,
5755 errmsg("invalid Unicode code point: %04X", unicode));
5756
5757 if (pair_first)
5758 {
5760 {
5762 pair_first = 0;
5763 }
5764 else
5765 goto invalid_pair;
5766 }
5768 goto invalid_pair;
5769
5772 else
5773 {
5774 pg_unicode_to_server(unicode, (unsigned char *) cbuf);
5776 }
5777
5778 instr += 10;
5779 len -= 10;
5780 }
5781 else
5782 ereport(ERROR,
5784 errmsg("invalid Unicode escape"),
5785 errhint("Unicode escapes must be \\XXXX, \\+XXXXXX, \\uXXXX, or \\UXXXXXXXX.")));
5786 }
5787 else
5788 {
5789 if (pair_first)
5790 goto invalid_pair;
5791
5792 appendStringInfoChar(&str, *instr++);
5793 len--;
5794 }
5795 }
5796
5797 /* unfinished surrogate pair? */
5798 if (pair_first)
5799 goto invalid_pair;
5800
5802 pfree(str.data);
5803
5805
5807 ereport(ERROR,
5809 errmsg("invalid Unicode surrogate pair")));
5810 PG_RETURN_NULL(); /* keep compiler quiet */
5811}
void pg_unicode_to_server(char32_t c, unsigned char *s)
Definition mbutils.c:875
static bool is_utf16_surrogate_first(char32_t c)
Definition pg_wchar.h:378
static bool is_utf16_surrogate_second(char32_t c)
Definition pg_wchar.h:384
static char32_t surrogate_pair_to_codepoint(char16_t first, char16_t second)
Definition pg_wchar.h:390
#define MAX_UNICODE_EQUIVALENT_STRING
Definition pg_wchar.h:182
static bool is_valid_unicode_codepoint(char32_t c)
Definition pg_wchar.h:372
static unsigned int hexval_n(const char *instr, size_t n)
Definition varlena.c:5632
static bool isxdigits_n(const char *instr, size_t n)
Definition varlena.c:5606

References appendStringInfoChar(), appendStringInfoString(), cstring_to_text_with_len(), ereport, errcode(), errhint(), errmsg, ERROR, fb(), hexval_n(), initStringInfo(), is_utf16_surrogate_first(), is_utf16_surrogate_second(), is_valid_unicode_codepoint(), isxdigits_n(), len, MAX_UNICODE_EQUIVALENT_STRING, pfree(), PG_GETARG_TEXT_PP, PG_RETURN_NULL, PG_RETURN_TEXT_P, pg_unicode_to_server(), result, str, surrogate_pair_to_codepoint(), VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

◆ unknownin()

Datum unknownin ( PG_FUNCTION_ARGS  )

Definition at line 333 of file varlena.c.

334{
335 char *str = PG_GETARG_CSTRING(0);
336
337 /* representation is same as cstring */
339}

References PG_GETARG_CSTRING, PG_RETURN_CSTRING, pstrdup(), and str.

◆ unknownout()

Datum unknownout ( PG_FUNCTION_ARGS  )

Definition at line 345 of file varlena.c.

346{
347 /* representation is same as cstring */
348 char *str = PG_GETARG_CSTRING(0);
349
351}

References PG_GETARG_CSTRING, PG_RETURN_CSTRING, pstrdup(), and str.

◆ unknownrecv()

Datum unknownrecv ( PG_FUNCTION_ARGS  )

Definition at line 357 of file varlena.c.

358{
360 char *str;
361 int nbytes;
362
363 str = pq_getmsgtext(buf, buf->len - buf->cursor, &nbytes);
364 /* representation is same as cstring */
366}

References buf, PG_GETARG_POINTER, PG_RETURN_CSTRING, pq_getmsgtext(), and str.

◆ unknownsend()

Datum unknownsend ( PG_FUNCTION_ARGS  )

Definition at line 372 of file varlena.c.

373{
374 /* representation is same as cstring */
375 char *str = PG_GETARG_CSTRING(0);
377
381}

References buf, fb(), PG_GETARG_CSTRING, PG_RETURN_BYTEA_P, pq_begintypsend(), pq_endtypsend(), pq_sendtext(), and str.

◆ updateClosestMatch()

void updateClosestMatch ( ClosestMatchState state,
const char candidate 
)

Definition at line 5351 of file varlena.c.

5352{
5353 int dist;
5354
5355 Assert(state);
5356
5357 if (state->source == NULL || state->source[0] == '\0' ||
5358 candidate == NULL || candidate[0] == '\0')
5359 return;
5360
5361 /*
5362 * To avoid ERROR-ing, we check the lengths here instead of setting
5363 * 'trusted' to false in the call to varstr_levenshtein_less_equal().
5364 */
5365 if (strlen(state->source) > MAX_LEVENSHTEIN_STRLEN ||
5367 return;
5368
5370 candidate, strlen(candidate), 1, 1, 1,
5371 state->max_d, true);
5372 if (dist <= state->max_d &&
5373 dist <= strlen(state->source) / 2 &&
5374 (state->min_d == -1 || dist < state->min_d))
5375 {
5376 state->min_d = dist;
5377 state->match = candidate;
5378 }
5379}
#define MAX_LEVENSHTEIN_STRLEN
Definition levenshtein.c:26
int varstr_levenshtein_less_equal(const char *source, int slen, const char *target, int tlen, int ins_c, int del_c, int sub_c, int max_d, bool trusted)

References Assert, fb(), MAX_LEVENSHTEIN_STRLEN, and varstr_levenshtein_less_equal().

Referenced by dblink_fdw_validator(), file_fdw_validator(), postgres_fdw_validator(), and postgresql_fdw_validator().

◆ varlenafastcmp_locale()

static int varlenafastcmp_locale ( Datum  x,
Datum  y,
SortSupport  ssup 
)
static

Definition at line 1889 of file varlena.c.

1890{
1893 char *a1p,
1894 *a2p;
1895 int len1,
1896 len2,
1897 result;
1898
1899 a1p = VARDATA_ANY(arg1);
1900 a2p = VARDATA_ANY(arg2);
1901
1902 len1 = VARSIZE_ANY_EXHDR(arg1);
1903 len2 = VARSIZE_ANY_EXHDR(arg2);
1904
1905 result = varstrfastcmp_locale(a1p, len1, a2p, len2, ssup);
1906
1907 /* We can't afford to leak memory here. */
1908 if (PointerGetDatum(arg1) != x)
1909 pfree(arg1);
1910 if (PointerGetDatum(arg2) != y)
1911 pfree(arg2);
1912
1913 return result;
1914}
#define DatumGetVarStringPP(X)
Definition varlena.c:122

References DatumGetVarStringPP, fb(), pfree(), PointerGetDatum, result, VARDATA_ANY(), VARSIZE_ANY_EXHDR(), varstrfastcmp_locale(), x, and y.

Referenced by varstr_sortsupport().

◆ varstr_abbrev_abort()

static bool varstr_abbrev_abort ( int  memtupcount,
SortSupport  ssup 
)
static

Definition at line 2201 of file varlena.c.

2202{
2204 double abbrev_distinct,
2206
2207 Assert(ssup->abbreviate);
2208
2209 /* Have a little patience */
2210 if (memtupcount < 100)
2211 return false;
2212
2214 key_distinct = estimateHyperLogLog(&sss->full_card);
2215
2216 /*
2217 * Clamp cardinality estimates to at least one distinct value. While
2218 * NULLs are generally disregarded, if only NULL values were seen so far,
2219 * that might misrepresent costs if we failed to clamp.
2220 */
2221 if (abbrev_distinct < 1.0)
2222 abbrev_distinct = 1.0;
2223
2224 if (key_distinct < 1.0)
2225 key_distinct = 1.0;
2226
2227 /*
2228 * In the worst case all abbreviated keys are identical, while at the same
2229 * time there are differences within full key strings not captured in
2230 * abbreviations.
2231 */
2232 if (trace_sort)
2233 {
2234 double norm_abbrev_card = abbrev_distinct / (double) memtupcount;
2235
2236 elog(LOG, "varstr_abbrev: abbrev_distinct after %d: %f "
2237 "(key_distinct: %f, norm_abbrev_card: %f, prop_card: %f)",
2239 sss->prop_card);
2240 }
2241
2242 /*
2243 * If the number of distinct abbreviated keys approximately matches the
2244 * number of distinct authoritative original keys, that's reason enough to
2245 * proceed. We can win even with a very low cardinality set if most
2246 * tie-breakers only memcmp(). This is by far the most important
2247 * consideration.
2248 *
2249 * While comparisons that are resolved at the abbreviated key level are
2250 * considerably cheaper than tie-breakers resolved with memcmp(), both of
2251 * those two outcomes are so much cheaper than a full strcoll() once
2252 * sorting is underway that it doesn't seem worth it to weigh abbreviated
2253 * cardinality against the overall size of the set in order to more
2254 * accurately model costs. Assume that an abbreviated comparison, and an
2255 * abbreviated comparison with a cheap memcmp()-based authoritative
2256 * resolution are equivalent.
2257 */
2258 if (abbrev_distinct > key_distinct * sss->prop_card)
2259 {
2260 /*
2261 * When we have exceeded 10,000 tuples, decay required cardinality
2262 * aggressively for next call.
2263 *
2264 * This is useful because the number of comparisons required on
2265 * average increases at a linearithmic rate, and at roughly 10,000
2266 * tuples that factor will start to dominate over the linear costs of
2267 * string transformation (this is a conservative estimate). The decay
2268 * rate is chosen to be a little less aggressive than halving -- which
2269 * (since we're called at points at which memtupcount has doubled)
2270 * would never see the cost model actually abort past the first call
2271 * following a decay. This decay rate is mostly a precaution against
2272 * a sudden, violent swing in how well abbreviated cardinality tracks
2273 * full key cardinality. The decay also serves to prevent a marginal
2274 * case from being aborted too late, when too much has already been
2275 * invested in string transformation.
2276 *
2277 * It's possible for sets of several million distinct strings with
2278 * mere tens of thousands of distinct abbreviated keys to still
2279 * benefit very significantly. This will generally occur provided
2280 * each abbreviated key is a proxy for a roughly uniform number of the
2281 * set's full keys. If it isn't so, we hope to catch that early and
2282 * abort. If it isn't caught early, by the time the problem is
2283 * apparent it's probably not worth aborting.
2284 */
2285 if (memtupcount > 10000)
2286 sss->prop_card *= 0.65;
2287
2288 return false;
2289 }
2290
2291 /*
2292 * Abort abbreviation strategy.
2293 *
2294 * The worst case, where all abbreviated keys are identical while all
2295 * original strings differ will typically only see a regression of about
2296 * 10% in execution time for small to medium sized lists of strings.
2297 * Whereas on modern CPUs where cache stalls are the dominant cost, we can
2298 * often expect very large improvements, particularly with sets of strings
2299 * of moderately high to high abbreviated cardinality. There is little to
2300 * lose but much to gain, which our strategy reflects.
2301 */
2302 if (trace_sort)
2303 elog(LOG, "varstr_abbrev: aborted abbreviation at %d "
2304 "(abbrev_distinct: %f, key_distinct: %f, prop_card: %f)",
2305 memtupcount, abbrev_distinct, key_distinct, sss->prop_card);
2306
2307 return true;
2308}
#define LOG
Definition elog.h:32
double estimateHyperLogLog(hyperLogLogState *cState)
bool trace_sort
Definition tuplesort.c:123

References SortSupportData::abbreviate, Assert, elog, estimateHyperLogLog(), fb(), LOG, SortSupportData::ssup_extra, and trace_sort.

Referenced by varstr_sortsupport().

◆ varstr_abbrev_convert()

static Datum varstr_abbrev_convert ( Datum  original,
SortSupport  ssup 
)
static

Definition at line 2034 of file varlena.c.

2035{
2036 const size_t max_prefix_bytes = sizeof(Datum);
2040
2041 /* working state */
2042 Datum res;
2043 char *pres;
2044 int len;
2045 uint32 hash;
2046
2047 pres = (char *) &res;
2048 /* memset(), so any non-overwritten bytes are NUL */
2051
2052 /* Get number of bytes, ignoring trailing spaces */
2053 if (sss->typid == BPCHAROID)
2055
2056 /*
2057 * If we're using the C collation, use memcpy(), rather than strxfrm(), to
2058 * abbreviate keys. The full comparator for the C locale is also
2059 * memcmp(). This should be faster than strxfrm().
2060 */
2061 if (sss->collate_c)
2063 else
2064 {
2065 Size bsize;
2066
2067 /*
2068 * We're not using the C collation, so fall back on strxfrm or ICU
2069 * analogs.
2070 */
2071
2072 /* By convention, we use buffer 1 to store and NUL-terminate */
2073 if (len >= sss->buflen1)
2074 {
2075 sss->buflen1 = Max(len + 1, Min(sss->buflen1 * 2, MaxAllocSize));
2076 sss->buf1 = repalloc(sss->buf1, sss->buflen1);
2077 }
2078
2079 /* Might be able to reuse strxfrm() blob from last call */
2080 if (sss->last_len1 == len && sss->cache_blob &&
2081 memcmp(sss->buf1, authoritative_data, len) == 0)
2082 {
2083 memcpy(pres, sss->buf2, Min(max_prefix_bytes, sss->last_len2));
2084 /* No change affecting cardinality, so no hashing required */
2085 goto done;
2086 }
2087
2089
2090 /*
2091 * pg_strxfrm() and pg_strxfrm_prefix expect NUL-terminated strings.
2092 */
2093 sss->buf1[len] = '\0';
2094 sss->last_len1 = len;
2095
2096 if (pg_strxfrm_prefix_enabled(sss->locale))
2097 {
2098 if (sss->buflen2 < max_prefix_bytes)
2099 {
2100 sss->buflen2 = Max(max_prefix_bytes,
2101 Min(sss->buflen2 * 2, MaxAllocSize));
2102 sss->buf2 = repalloc(sss->buf2, sss->buflen2);
2103 }
2104
2105 bsize = pg_strxfrm_prefix(sss->buf2, sss->buf1,
2106 max_prefix_bytes, sss->locale);
2107 sss->last_len2 = bsize;
2108 }
2109 else
2110 {
2111 /*
2112 * Loop: Call pg_strxfrm(), possibly enlarge buffer, and try
2113 * again. The pg_strxfrm() function leaves the result buffer
2114 * content undefined if the result did not fit, so we need to
2115 * retry until everything fits, even though we only need the first
2116 * few bytes in the end.
2117 */
2118 for (;;)
2119 {
2120 bsize = pg_strxfrm(sss->buf2, sss->buf1, sss->buflen2,
2121 sss->locale);
2122
2123 sss->last_len2 = bsize;
2124 if (bsize < sss->buflen2)
2125 break;
2126
2127 /*
2128 * Grow buffer and retry.
2129 */
2130 sss->buflen2 = Max(bsize + 1,
2131 Min(sss->buflen2 * 2, MaxAllocSize));
2132 sss->buf2 = repalloc(sss->buf2, sss->buflen2);
2133 }
2134 }
2135
2136 /*
2137 * Every Datum byte is always compared. This is safe because the
2138 * strxfrm() blob is itself NUL terminated, leaving no danger of
2139 * misinterpreting any NUL bytes not intended to be interpreted as
2140 * logically representing termination.
2141 */
2143 }
2144
2145 /*
2146 * Maintain approximate cardinality of both abbreviated keys and original,
2147 * authoritative keys using HyperLogLog. Used as cheap insurance against
2148 * the worst case, where we do many string transformations for no saving
2149 * in full strcoll()-based comparisons. These statistics are used by
2150 * varstr_abbrev_abort().
2151 *
2152 * First, Hash key proper, or a significant fraction of it. Mix in length
2153 * in order to compensate for cases where differences are past
2154 * PG_CACHE_LINE_SIZE bytes, so as to limit the overhead of hashing.
2155 */
2156 hash = DatumGetUInt32(hash_any((unsigned char *) authoritative_data,
2158
2159 if (len > PG_CACHE_LINE_SIZE)
2161
2162 addHyperLogLog(&sss->full_card, hash);
2163
2164 /* Hash abbreviated key */
2165 {
2166 uint32 tmp;
2167
2168 tmp = DatumGetUInt32(res) ^ (uint32) (DatumGetUInt64(res) >> 32);
2170 }
2171
2172 addHyperLogLog(&sss->abbr_card, hash);
2173
2174 /* Cache result, perhaps saving an expensive strxfrm() call next time */
2175 sss->cache_blob = true;
2176done:
2177
2178 /*
2179 * Byteswap on little-endian machines.
2180 *
2181 * This is needed so that ssup_datum_unsigned_cmp() (an unsigned integer
2182 * 3-way comparator) works correctly on all platforms. If we didn't do
2183 * this, the comparator would have to call memcmp() with a pair of
2184 * pointers to the first byte of each abbreviated key, which is slower.
2185 */
2186 res = DatumBigEndianToNative(res);
2187
2188 /* Don't leak memory here */
2189 if (PointerGetDatum(authoritative) != original)
2191
2192 return res;
2193}
#define MaxAllocSize
Definition fe_memutils.h:22
static Datum hash_uint32(uint32 k)
Definition hashfn.h:43
static Datum hash_any(const unsigned char *k, int keylen)
Definition hashfn.h:31
void addHyperLogLog(hyperLogLogState *cState, uint32 hash)
void * repalloc(void *pointer, Size size)
Definition mcxt.c:1632
#define DatumBigEndianToNative(x)
Definition pg_bswap.h:145
#define PG_CACHE_LINE_SIZE
bool pg_strxfrm_prefix_enabled(pg_locale_t locale)
Definition pg_locale.c:1470
size_t pg_strxfrm(char *dest, const char *src, size_t destsize, pg_locale_t locale)
Definition pg_locale.c:1434
size_t pg_strxfrm_prefix(char *dest, const char *src, size_t destsize, pg_locale_t locale)
Definition pg_locale.c:1481
static uint32 DatumGetUInt32(Datum X)
Definition postgres.h:222
static uint64 DatumGetUInt64(Datum X)
Definition postgres.h:436
static unsigned hash(unsigned *uv, int n)
Definition rege_dfa.c:715

References addHyperLogLog(), bpchartruelen(), DatumBigEndianToNative, DatumGetUInt32(), DatumGetUInt64(), DatumGetVarStringPP, fb(), hash(), hash_any(), hash_uint32(), len, Max, MaxAllocSize, memcpy(), Min, pfree(), PG_CACHE_LINE_SIZE, pg_strxfrm(), pg_strxfrm_prefix(), pg_strxfrm_prefix_enabled(), PointerGetDatum, repalloc(), SortSupportData::ssup_extra, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

Referenced by varstr_sortsupport().

◆ varstr_cmp()

int varstr_cmp ( const char arg1,
int  len1,
const char arg2,
int  len2,
Oid  collid 
)

Definition at line 1355 of file varlena.c.

1356{
1357 int result;
1359
1361
1363
1364 if (mylocale->collate_is_c)
1365 {
1366 result = memcmp(arg1, arg2, Min(len1, len2));
1367 if ((result == 0) && (len1 != len2))
1368 result = (len1 < len2) ? -1 : 1;
1369 }
1370 else
1371 {
1372 /*
1373 * memcmp() can't tell us which of two unequal strings sorts first,
1374 * but it's a cheap way to tell if they're equal. Testing shows that
1375 * memcmp() followed by strcoll() is only trivially slower than
1376 * strcoll() by itself, so we don't lose much if this doesn't work out
1377 * very often, and if it does - for example, because there are many
1378 * equal strings in the input - then we win big by avoiding expensive
1379 * collation-aware comparisons.
1380 */
1381 if (len1 == len2 && memcmp(arg1, arg2, len1) == 0)
1382 return 0;
1383
1384 result = pg_strncoll(arg1, len1, arg2, len2, mylocale);
1385
1386 /* Break tie if necessary. */
1387 if (result == 0 && mylocale->deterministic)
1388 {
1389 result = memcmp(arg1, arg2, Min(len1, len2));
1390 if ((result == 0) && (len1 != len2))
1391 result = (len1 < len2) ? -1 : 1;
1392 }
1393 }
1394
1395 return result;
1396}

References check_collation_set(), collid, fb(), Min, pg_newlocale_from_collation(), pg_strncoll(), and result.

Referenced by bpchar_larger(), bpchar_smaller(), bpcharcmp(), bpchareq(), bpcharge(), bpchargt(), bpcharle(), bpcharlt(), bpcharne(), btnametextcmp(), bttextnamecmp(), citextcmp(), compareJsonbScalarValue(), gin_compare_jsonb(), make_greater_string(), namecmp(), nameeqtext(), namenetext(), spg_text_leaf_consistent(), text_cmp(), texteqname(), and textnename().

◆ varstr_sortsupport()

void varstr_sortsupport ( SortSupport  ssup,
Oid  typid,
Oid  collid 
)

Definition at line 1671 of file varlena.c.

1672{
1673 bool abbreviate = ssup->abbreviate;
1674 bool collate_c = false;
1676 pg_locale_t locale;
1677
1679
1681
1682 /*
1683 * If possible, set ssup->comparator to a function which can be used to
1684 * directly compare two datums. If we can do this, we'll avoid the
1685 * overhead of a trip through the fmgr layer for every comparison, which
1686 * can be substantial.
1687 *
1688 * Most typically, we'll set the comparator to varlenafastcmp_locale,
1689 * which uses strcoll() to perform comparisons. We use that for the
1690 * BpChar case too, but type NAME uses namefastcmp_locale. However, if
1691 * LC_COLLATE = C, we can make things quite a bit faster with
1692 * varstrfastcmp_c, bpcharfastcmp_c, or namefastcmp_c, all of which use
1693 * memcmp() rather than strcoll().
1694 */
1695 if (locale->collate_is_c)
1696 {
1697 if (typid == BPCHAROID)
1699 else if (typid == NAMEOID)
1700 {
1701 ssup->comparator = namefastcmp_c;
1702 /* Not supporting abbreviation with type NAME, for now */
1703 abbreviate = false;
1704 }
1705 else
1707
1708 collate_c = true;
1709 }
1710 else
1711 {
1712 /*
1713 * We use varlenafastcmp_locale except for type NAME.
1714 */
1715 if (typid == NAMEOID)
1716 {
1718 /* Not supporting abbreviation with type NAME, for now */
1719 abbreviate = false;
1720 }
1721 else
1723
1724 /*
1725 * Unfortunately, it seems that abbreviation for non-C collations is
1726 * broken on many common platforms; see pg_strxfrm_enabled().
1727 *
1728 * Even apart from the risk of broken locales, it's possible that
1729 * there are platforms where the use of abbreviated keys should be
1730 * disabled at compile time. For example, macOS's strxfrm()
1731 * implementation is known to not effectively concentrate a
1732 * significant amount of entropy from the original string in earlier
1733 * transformed blobs. It's possible that other supported platforms
1734 * are similarly encumbered. So, if we ever get past disabling this
1735 * categorically, we may still want or need to disable it for
1736 * particular platforms.
1737 */
1738 if (!pg_strxfrm_enabled(locale))
1739 abbreviate = false;
1740 }
1741
1742 /*
1743 * If we're using abbreviated keys, or if we're using a locale-aware
1744 * comparison, we need to initialize a VarStringSortSupport object. Both
1745 * cases will make use of the temporary buffers we initialize here for
1746 * scratch space (and to detect requirement for BpChar semantics from
1747 * caller), and the abbreviation case requires additional state.
1748 */
1749 if (abbreviate || !collate_c)
1750 {
1752 sss->buf1 = palloc(TEXTBUFLEN);
1753 sss->buflen1 = TEXTBUFLEN;
1754 sss->buf2 = palloc(TEXTBUFLEN);
1755 sss->buflen2 = TEXTBUFLEN;
1756 /* Start with invalid values */
1757 sss->last_len1 = -1;
1758 sss->last_len2 = -1;
1759 /* Initialize */
1760 sss->last_returned = 0;
1761 if (collate_c)
1762 sss->locale = NULL;
1763 else
1764 sss->locale = locale;
1765
1766 /*
1767 * To avoid somehow confusing a strxfrm() blob and an original string,
1768 * constantly keep track of the variety of data that buf1 and buf2
1769 * currently contain.
1770 *
1771 * Comparisons may be interleaved with conversion calls. Frequently,
1772 * conversions and comparisons are batched into two distinct phases,
1773 * but the correctness of caching cannot hinge upon this. For
1774 * comparison caching, buffer state is only trusted if cache_blob is
1775 * found set to false, whereas strxfrm() caching only trusts the state
1776 * when cache_blob is found set to true.
1777 *
1778 * Arbitrarily initialize cache_blob to true.
1779 */
1780 sss->cache_blob = true;
1781 sss->collate_c = collate_c;
1782 sss->typid = typid;
1783 ssup->ssup_extra = sss;
1784
1785 /*
1786 * If possible, plan to use the abbreviated keys optimization. The
1787 * core code may switch back to authoritative comparator should
1788 * abbreviation be aborted.
1789 */
1790 if (abbreviate)
1791 {
1792 sss->prop_card = 0.20;
1793 initHyperLogLog(&sss->abbr_card, 10);
1794 initHyperLogLog(&sss->full_card, 10);
1795 ssup->abbrev_full_comparator = ssup->comparator;
1799 }
1800 }
1801}
#define palloc_object(type)
Definition fe_memutils.h:74
void initHyperLogLog(hyperLogLogState *cState, uint8 bwidth)
Definition hyperloglog.c:66
bool pg_strxfrm_enabled(pg_locale_t locale)
Definition pg_locale.c:1418
int(* comparator)(Datum x, Datum y, SortSupport ssup)
Datum(* abbrev_converter)(Datum original, SortSupport ssup)
int(* abbrev_full_comparator)(Datum x, Datum y, SortSupport ssup)
bool(* abbrev_abort)(int memtupcount, SortSupport ssup)
int ssup_datum_unsigned_cmp(Datum x, Datum y, SortSupport ssup)
Definition tuplesort.c:3447
static bool varstr_abbrev_abort(int memtupcount, SortSupport ssup)
Definition varlena.c:2201
static int varlenafastcmp_locale(Datum x, Datum y, SortSupport ssup)
Definition varlena.c:1889
static int bpcharfastcmp_c(Datum x, Datum y, SortSupport ssup)
Definition varlena.c:1844
static int namefastcmp_c(Datum x, Datum y, SortSupport ssup)
Definition varlena.c:1877
static int namefastcmp_locale(Datum x, Datum y, SortSupport ssup)
Definition varlena.c:1920
static Datum varstr_abbrev_convert(Datum original, SortSupport ssup)
Definition varlena.c:2034
static int varstrfastcmp_c(Datum x, Datum y, SortSupport ssup)
Definition varlena.c:1807
#define TEXTBUFLEN
Definition varlena.c:119

References SortSupportData::abbrev_abort, SortSupportData::abbrev_converter, SortSupportData::abbrev_full_comparator, SortSupportData::abbreviate, bpcharfastcmp_c(), check_collation_set(), pg_locale_struct::collate_is_c, collid, SortSupportData::comparator, fb(), initHyperLogLog(), namefastcmp_c(), namefastcmp_locale(), palloc(), palloc_object, pg_newlocale_from_collation(), pg_strxfrm_enabled(), ssup_datum_unsigned_cmp(), SortSupportData::ssup_extra, TEXTBUFLEN, varlenafastcmp_locale(), varstr_abbrev_abort(), varstr_abbrev_convert(), and varstrfastcmp_c().

Referenced by bpchar_sortsupport(), btbpchar_pattern_sortsupport(), btnamesortsupport(), bttext_pattern_sortsupport(), and bttextsortsupport().

◆ varstrfastcmp_c()

static int varstrfastcmp_c ( Datum  x,
Datum  y,
SortSupport  ssup 
)
static

Definition at line 1807 of file varlena.c.

1808{
1811 char *a1p,
1812 *a2p;
1813 int len1,
1814 len2,
1815 result;
1816
1817 a1p = VARDATA_ANY(arg1);
1818 a2p = VARDATA_ANY(arg2);
1819
1820 len1 = VARSIZE_ANY_EXHDR(arg1);
1821 len2 = VARSIZE_ANY_EXHDR(arg2);
1822
1823 result = memcmp(a1p, a2p, Min(len1, len2));
1824 if ((result == 0) && (len1 != len2))
1825 result = (len1 < len2) ? -1 : 1;
1826
1827 /* We can't afford to leak memory here. */
1828 if (PointerGetDatum(arg1) != x)
1829 pfree(arg1);
1830 if (PointerGetDatum(arg2) != y)
1831 pfree(arg2);
1832
1833 return result;
1834}

References DatumGetVarStringPP, fb(), Min, pfree(), PointerGetDatum, result, VARDATA_ANY(), VARSIZE_ANY_EXHDR(), x, and y.

Referenced by varstr_sortsupport().

◆ varstrfastcmp_locale()

static int varstrfastcmp_locale ( char a1p,
int  len1,
char a2p,
int  len2,
SortSupport  ssup 
)
static

Definition at line 1934 of file varlena.c.

1935{
1937 int result;
1938 bool arg1_match;
1939
1940 /* Fast pre-check for equality, as discussed in varstr_cmp() */
1941 if (len1 == len2 && memcmp(a1p, a2p, len1) == 0)
1942 {
1943 /*
1944 * No change in buf1 or buf2 contents, so avoid changing last_len1 or
1945 * last_len2. Existing contents of buffers might still be used by
1946 * next call.
1947 *
1948 * It's fine to allow the comparison of BpChar padding bytes here,
1949 * even though that implies that the memcmp() will usually be
1950 * performed for BpChar callers (though multibyte characters could
1951 * still prevent that from occurring). The memcmp() is still very
1952 * cheap, and BpChar's funny semantics have us remove trailing spaces
1953 * (not limited to padding), so we need make no distinction between
1954 * padding space characters and "real" space characters.
1955 */
1956 return 0;
1957 }
1958
1959 if (sss->typid == BPCHAROID)
1960 {
1961 /* Get true number of bytes, ignoring trailing spaces */
1962 len1 = bpchartruelen(a1p, len1);
1963 len2 = bpchartruelen(a2p, len2);
1964 }
1965
1966 if (len1 >= sss->buflen1)
1967 {
1968 sss->buflen1 = Max(len1 + 1, Min(sss->buflen1 * 2, MaxAllocSize));
1969 sss->buf1 = repalloc(sss->buf1, sss->buflen1);
1970 }
1971 if (len2 >= sss->buflen2)
1972 {
1973 sss->buflen2 = Max(len2 + 1, Min(sss->buflen2 * 2, MaxAllocSize));
1974 sss->buf2 = repalloc(sss->buf2, sss->buflen2);
1975 }
1976
1977 /*
1978 * We're likely to be asked to compare the same strings repeatedly, and
1979 * memcmp() is so much cheaper than strcoll() that it pays to try to cache
1980 * comparisons, even though in general there is no reason to think that
1981 * that will work out (every string datum may be unique). Caching does
1982 * not slow things down measurably when it doesn't work out, and can speed
1983 * things up by rather a lot when it does. In part, this is because the
1984 * memcmp() compares data from cachelines that are needed in L1 cache even
1985 * when the last comparison's result cannot be reused.
1986 */
1987 arg1_match = true;
1988 if (len1 != sss->last_len1 || memcmp(sss->buf1, a1p, len1) != 0)
1989 {
1990 arg1_match = false;
1991 memcpy(sss->buf1, a1p, len1);
1992 sss->buf1[len1] = '\0';
1993 sss->last_len1 = len1;
1994 }
1995
1996 /*
1997 * If we're comparing the same two strings as last time, we can return the
1998 * same answer without calling strcoll() again. This is more likely than
1999 * it seems (at least with moderate to low cardinality sets), because
2000 * quicksort compares the same pivot against many values.
2001 */
2002 if (len2 != sss->last_len2 || memcmp(sss->buf2, a2p, len2) != 0)
2003 {
2004 memcpy(sss->buf2, a2p, len2);
2005 sss->buf2[len2] = '\0';
2006 sss->last_len2 = len2;
2007 }
2008 else if (arg1_match && !sss->cache_blob)
2009 {
2010 /* Use result cached following last actual strcoll() call */
2011 return sss->last_returned;
2012 }
2013
2014 result = pg_strcoll(sss->buf1, sss->buf2, sss->locale);
2015
2016 /* Break tie if necessary. */
2017 if (result == 0 && sss->locale->deterministic)
2018 result = strcmp(sss->buf1, sss->buf2);
2019
2020 /* Cache result, perhaps saving an expensive strcoll() call next time */
2021 sss->cache_blob = false;
2022 sss->last_returned = result;
2023 return result;
2024}
int pg_strcoll(const char *arg1, const char *arg2, pg_locale_t locale)
Definition pg_locale.c:1384

References bpchartruelen(), fb(), Max, MaxAllocSize, memcpy(), Min, pg_strcoll(), repalloc(), result, and SortSupportData::ssup_extra.

Referenced by namefastcmp_locale(), and varlenafastcmp_locale().