1 /* -----------------------------------------------------------------------
2  * formatting.h
3  *
4  * src/include/utils/formatting.h
5  *
6  *
7  *	 Portions Copyright (c) 1999-2016, PostgreSQL Global Development Group
8  *
9  *	 The PostgreSQL routines for a DateTime/int/float/numeric formatting,
10  *	 inspire with Oracle TO_CHAR() / TO_DATE() / TO_NUMBER() routines.
11  *
12  *	 Karel Zak
13  *
14  * -----------------------------------------------------------------------
15  */
16 
17 #ifndef _FORMATTING_H_
18 #define _FORMATTING_H_
19 
20 #include "fmgr.h"
21 
22 
23 extern char *str_tolower(const char *buff, size_t nbytes, Oid collid);
24 extern char *str_toupper(const char *buff, size_t nbytes, Oid collid);
25 extern char *str_initcap(const char *buff, size_t nbytes, Oid collid);
26 
27 extern char *asc_tolower(const char *buff, size_t nbytes);
28 extern char *asc_toupper(const char *buff, size_t nbytes);
29 extern char *asc_initcap(const char *buff, size_t nbytes);
30 
31 extern Datum timestamp_to_char(PG_FUNCTION_ARGS);
32 extern Datum timestamptz_to_char(PG_FUNCTION_ARGS);
33 extern Datum interval_to_char(PG_FUNCTION_ARGS);
34 extern Datum to_timestamp(PG_FUNCTION_ARGS);
35 extern Datum to_date(PG_FUNCTION_ARGS);
36 extern Datum numeric_to_number(PG_FUNCTION_ARGS);
37 extern Datum numeric_to_char(PG_FUNCTION_ARGS);
38 extern Datum int4_to_char(PG_FUNCTION_ARGS);
39 extern Datum int8_to_char(PG_FUNCTION_ARGS);
40 extern Datum float4_to_char(PG_FUNCTION_ARGS);
41 extern Datum float8_to_char(PG_FUNCTION_ARGS);
42 
43 #endif
44