aboutsummaryrefslogtreecommitdiff
path: root/src/backend/utils/adt/oracle_compat.c
Commit message (Collapse)AuthorAge
* Functions on 'text' type updated to new fmgr style. 'text' isTom Lane2000-07-06
| | | | now TOAST-able.
* TOASTJan Wieck2000-07-03
| | | | | | | | WARNING: This is actually broken - we have self-deadlocks due to concurrent changes in buffer management. Vadim and me are working on it. Jan
* Another batch of fmgr updates. I think I have gotten all old-styleTom Lane2000-06-13
| | | | | functions that take pass-by-value datatypes. Should be ready for port testing ...
* Ye-old pgindent run. Same 4-space tabs.Bruce Momjian2000-04-12
|
* Add transcendental math functions (sine, cosine, etc)Thomas G. Lockhart2000-04-07
| | | | | | | | | | | | | | | | Add a random number generator and seed setter (random(), SET SEED) Fix up the interval*float8 math to carry partial months into the time field. Add float8*interval so we have symmetry in the available math. Fix the parser and define.c to accept SQL92 types as field arguments. Fix the parser to accept SQL92 types for CREATE TYPE, etc. This is necessary to allow... Bit/varbit support in contrib/bit cleaned up to compile and load cleanly. Still needs some work before final release. Implement the "SOME" keyword as a synonym for "ANY" per SQL92. Implement ascii(text), ichar(int4), repeat(text,int4) to help support the ODBC driver. Enable the TRUNCATE() function mapping in the ODBC driver.
* Fix busted TRANSLATE() code --- it coredumped due to pfree()'ing theTom Lane2000-03-15
| | | | wrong pointer.
* Implement column aliases on views "CREATE VIEW name (collist)".Thomas G. Lockhart2000-03-14
| | | | | | | | | | | | | | | | | | Implement TIME WITH TIME ZONE type (timetz internal type). Remap length() for character strings to CHAR_LENGTH() for SQL92 and to remove the ambiguity with geometric length() functions. Keep length() for character strings for backward compatibility. Shrink stored views by removing internal column name list from visible rte. Implement min(), max() for time and timetz data types. Implement conversion of TIME to INTERVAL. Implement abs(), mod(), fac() for the int8 data type. Rename some math functions to generic names: round(), sqrt(), cbrt(), pow(), etc. Rename NUMERIC power() function to pow(). Fix int2 factorial to calculate result in int4. Enhance the Oracle compatibility function translate() to work with string arguments (from Edwin Ramirez). Modify pg_proc system table to remove OID holes.
* Clean up #include in /include directory. Add scripts for checking includes.Bruce Momjian1999-07-15
|
* Cleanup of /include #include's, for 6.6 only.Bruce Momjian1999-07-14
|
* Make functions static or NOT_USED as appropriate.Bruce Momjian1999-05-26
|
* From: Tatsuo Ishii <t-ishii@sra.co.jp>Marc G. Fournier1999-02-21
| | | | | | Ok. I made patches replacing all of "#if FALSE" or "#if 0" to "#ifdef NOT_USED" for current. I have tested these patches in that the postgres binaries are identical.
* OK, folks, here is the pgindent output.Bruce Momjian1998-09-01
|
* the following patch fixes a bug in the oracle compatibilityBruce Momjian1998-08-11
| | | | | | | | | | | | | | | | | | | | functions btrim() ltrim() and rtrim(). The error was that the character after the set was included in the tests (ptr2 pointed to the character after the vardata part of set if no match found, so comparing *ptr or *end against *ptr2 MAY match -> strip). Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #======================================== jwieck@debis.com (Jan Wieck) #
* Remove un-needed braces around single statements.Bruce Momjian1998-06-15
|
* From: t-ishii@sra.co.jpMarc G. Fournier1998-04-27
| | | | | | | | | | | | | | | | | | | | | | | Hi, here are patches I promised (against 6.3.2): * character_length(), position(), substring() are now aware of multi-byte characters * add octet_length() * add --with-mb option to configure * new regression tests for EUC_KR (contributed by "Soonmyung. Hong" <hong@lunaris.hanmesoft.co.kr>) * add some test cases to the EUC_JP regression test * fix problem in regress/regress.sh in case of System V * fix toupper(), tolower() to handle 8bit chars note that: o patches for both configure.in and configure are included. maybe the one for configure is not necessary. o pg_proc.h was modified to add octet_length(). I used OIDs (1374-1379) for that. Please let me know if these numbers are not appropriate.
* pgindent run before 6.3 release, with Thomas' requested changes.Bruce Momjian1998-02-26
|
* > It seems there is a mistake in substr function:Marc G. Fournier1998-01-13
| | | | | | | | | | | | | | | > then you try get substr, which consists only of last char in string > you get all string > > For example: > userbase=> select substr('123456', 6,1) ; > substr > ------ > 123456 > (1 row) > From Edmund Mergl <E.Mergl@bawue.de>
* Used modified version of indent that understands over 100 typedefs.Bruce Momjian1997-09-08
|
* Another PGINDENT run that changes variable indenting and case label ↵Bruce Momjian1997-09-08
| | | | indenting. Also static variable indenting.
* Massive commit to run PGINDENT on all *.c and *.h files.Bruce Momjian1997-09-07
|
* Add routines for text trimming on both ends, substring, and string position.Thomas G. Lockhart1997-07-29
| | | | Used to support SQL92 compatibility.
* From: Erich Stamberger <eberger@gewi.kfunigraz.ac.at>Marc G. Fournier1997-05-07
| | | | Subject: [PATCHES] oracle_compat functions core dumping on NULL-fields
* oracle_compat.c fixed for function overloading...Marc G. Fournier1997-03-16
| | | | By: From: Edmund Mergl <mergl@nadia.s.bawue.de>
* Remove extra functions temporarily while a proper fix is found...Marc G. Fournier1997-03-16
|
* Update oracle_compat.cMarc G. Fournier1997-03-15
|
* Add prototypes for oracle-compat functions. Rename geo-*.c adt to geo_*.cBruce Momjian1997-03-09
|
* This is a set of single row character functions, defined for the datatypeMarc G. Fournier1997-03-04
text, which are supposed to behave exactly as their Oracle counterparts. From: Edmund Mergl <E.Mergl@bawue.de>
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-02 05:29:30 +0000