Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit6de7d4f

Browse files
committed
Update to /contrib from Karel.
1 parentb2c5657 commit6de7d4f

File tree

87 files changed

+257
-1645
lines changed

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

87 files changed

+257
-1645
lines changed

‎contrib/Contrib.index‎

Lines changed: 1 addition & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
The PostgreSQL contrib:
33
~~~~~~~~~~~~~~~~~~~~~~
44

5-
apache_logging -
5+
tips/apache_logging -
66
Getting Apache to log to PostgreSQL
77
by Terry Mackintosh <terry@terrym.com>
88

@@ -27,12 +27,6 @@ isbn_issn -
2727
PostgreSQL type extensions for ISBN (books) and ISSN (serials)
2828
by Garrett A. Wollman <wollman@khavrinen.lcs.mit.edu>
2929

30-
likeplanning -
31-
Scripts to enable/disable new planning code for LIKE and regexp
32-
pattern match operators. These will go away again once the code
33-
is mature enough to enable by default.
34-
by Tom Lane <tgl@sss.pgh.pa.us>
35-
3630
linux -
3731
Start postgres back end system
3832
by Thomas Lockhart <lockhart@alumni.caltech.edu>

‎contrib/Makefile‎

Lines changed: 1 addition & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@
33
#
44
#Portions Copyright (c) 1999-2000, PostgreSQL, Inc
55
#
6-
# $Header: /cvsroot/pgsql/contrib/Makefile,v 1.4 2000/06/15 18:54:29 momjian Exp $
6+
# $Header: /cvsroot/pgsql/contrib/Makefile,v 1.5 2000/06/19 13:52:59 momjian Exp $
77
#
88

99
TOPDIR = ..
@@ -14,7 +14,6 @@ WANTED_DIRS =array\
1414
findoidjoins\
1515
fulltextindex\
1616
isbn_issn\
17-
likeplanning\
1817
linux\
1918
lo\
2019
mSQL-interface\
@@ -31,7 +30,6 @@ WANTED_DIRS =array\
3130
userlock\
3231
vacuumlo
3332
#odbc
34-
#os2client
3533

3634

3735
all:

‎contrib/Makefile.global‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
#
99
#
1010
# IDENTIFICATION
11-
# $Header: /cvsroot/pgsql/contrib/Attic/Makefile.global,v 1.1 2000/06/15 19:04:37 momjian Exp $
11+
# $Header: /cvsroot/pgsql/contrib/Attic/Makefile.global,v 1.2 2000/06/19 13:52:59 momjian Exp $
1212
#
1313
#-------------------------------------------------------------------------
1414

‎contrib/README‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -3,18 +3,18 @@
33
~~~~~~~~~~~~~~~~~~~~~~~~~~~
44

55
FIXME:
6-
os2client
76
odbc
87
spi/preprocessor
98
tools
10-
9+
10+
- the contrib contain is in the "Contrib.index"
1111

1212
- in each directory must be Makefile, possible Makefile template
1313
is below this text,
1414

1515
--------
1616
#
17-
# $Header: /cvsroot/pgsql/contrib/README,v 1.18 2000/06/15 18:54:29 momjian Exp $
17+
# $Header: /cvsroot/pgsql/contrib/README,v 1.19 2000/06/19 13:52:59 momjian Exp $
1818
#
1919

2020
TOPDIR=../..

‎contrib/apache_logging/apachelog.sql‎

Whitespace-only changes.

‎contrib/apache_logging/httpconf.txt‎

Whitespace-only changes.

‎contrib/array/Makefile‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
#
2-
# $Header: /cvsroot/pgsql/contrib/array/Attic/Makefile,v 1.9 2000/06/16 18:58:25 momjian Exp $
2+
# $Header: /cvsroot/pgsql/contrib/array/Attic/Makefile,v 1.10 2000/06/19 13:53:03 momjian Exp $
33
#
44

55
TOPDIR=../..
@@ -10,7 +10,7 @@ NAME= array_iterator
1010

1111
PROGRAM=
1212
OBJS=$(NAME).o
13-
DOCS= README
13+
DOCS= README.$(NAME)
1414
SQLS=$(NAME).sql
1515
BINS=
1616
EXAMPLES=
@@ -29,7 +29,7 @@ install: install_doc install_sql install_mod
2929

3030
install_doc:
3131
forinst_filein$(DOCS);do \
32-
$(INSTALL)$(INSTL_LIB_OPTS)$$inst_file (CONTRIB_DOCDIR)/$(DOCS).$(NAME);\
32+
$(INSTALL)$(INSTL_LIB_OPTS)$$inst_file$(CONTRIB_DOCDIR);\
3333
done
3434

3535
install_sql:

‎contrib/array/README‎

Lines changed: 0 additions & 49 deletions
Original file line numberDiff line numberDiff line change
@@ -1,49 +0,0 @@
1-
Array iterator functions, by Massimo Dal Zotto <dz@cs.unitn.it>
2-
Copyright (C) 1999, Massimo Dal Zotto <dz@cs.unitn.it>
3-
4-
This software is distributed under the GNU General Public License
5-
either version 2, or (at your option) any later version.
6-
7-
8-
This loadable module defines a new class of functions which take
9-
an array and a scalar value, iterate a scalar operator over the
10-
elements of the array and the value, and compute a result as
11-
the logical OR or AND of the iteration results.
12-
For example array_int4eq returns true if some of the elements
13-
of an array of int4 is equal to the given value:
14-
15-
array_int4eq({1,2,3}, 1) --> true
16-
array_int4eq({1,2,3}, 4) --> false
17-
18-
If we have defined T array types and O scalar operators we can
19-
define T x O x 2 array functions, each of them has a name like
20-
"array_[all_]<basetype><operation>" and takes an array of type T
21-
iterating the operator O over all the elements. Note however
22-
that some of the possible combination are invalid, for example
23-
the array_int4_like because there is no like operator for int4.
24-
25-
We can then define new operators based on these functions and use
26-
them to write queries with qualification clauses based on the
27-
values of some of the elements of an array.
28-
For example to select rows having some or all element of an array
29-
attribute equal to a given value or matching a regular expression:
30-
31-
create table t(id int4[], txt text[]);
32-
33-
-- select tuples with some id element equal to 123
34-
select * from t where t.id *= 123;
35-
36-
-- select tuples with some txt element matching '[a-z]'
37-
select * from t where t.txt *~ '[a-z]';
38-
39-
-- select tuples with all txt elements matching '^[A-Z]'
40-
select * from t where t.txt[1:3] **~ '^[A-Z]';
41-
42-
The scheme is quite general, each operator which operates on a base type
43-
can be iterated over the elements of an array. It seem to work well but
44-
defining each new operators requires writing a different C function.
45-
Furthermore in each function there are two hardcoded OIDs which reference
46-
a base type and a procedure. Not very portable. Can anyone suggest a
47-
better and more portable way to do it ?
48-
49-
See also array_iterator.sql for an example on how to use this module.

‎contrib/bit/Makefile‎

Whitespace-only changes.

‎contrib/bit/README‎

Lines changed: 0 additions & 74 deletions
This file was deleted.

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp