diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 2002-06-11 15:44:38 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 2002-06-11 15:44:38 +0000 |
| commit | ea01a451ccec55cada68cb45a54519a750fd3d60 (patch) | |
| tree | e6f38191dbf7383eaf35f41009b37a13b2ce1fe7 /src/include/utils/builtins.h | |
| parent | 090dd22de67e6a7e50cfc3efb92a8472fa8750ba (diff) | |
Implement SQL99 OVERLAY(). Allows substitution of a substring in a string.
Implement SQL99 SIMILAR TO as a synonym for our existing operator "~".
Implement SQL99 regular expression SUBSTRING(string FROM pat FOR escape).
Extend the definition to make the FOR clause optional.
Define textregexsubstr() to actually implement this feature.
Update the regression test to include these new string features.
All tests pass.
Rename the regular expression support routines from "pg95_xxx" to "pg_xxx".
Define CREATE CHARACTER SET in the parser per SQL99. No implementation yet.
Diffstat (limited to 'src/include/utils/builtins.h')
| -rw-r--r-- | src/include/utils/builtins.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/include/utils/builtins.h b/src/include/utils/builtins.h index 6340aa22540..7676ce5663f 100644 --- a/src/include/utils/builtins.h +++ b/src/include/utils/builtins.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: builtins.h,v 1.182 2002/05/18 21:38:41 tgl Exp $ + * $Id: builtins.h,v 1.183 2002/06/11 15:41:38 thomas Exp $ * *------------------------------------------------------------------------- */ @@ -327,6 +327,7 @@ extern Datum nameicregexeq(PG_FUNCTION_ARGS); extern Datum nameicregexne(PG_FUNCTION_ARGS); extern Datum texticregexeq(PG_FUNCTION_ARGS); extern Datum texticregexne(PG_FUNCTION_ARGS); +extern Datum textregexsubstr(PG_FUNCTION_ARGS); /* regproc.c */ extern Datum regprocin(PG_FUNCTION_ARGS); |