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.

‎contrib/bit/varbit.c

Whitespace-only changes.

‎contrib/bit/varbit.demo.sql

Whitespace-only changes.

‎contrib/bit/varbit.drop.sql

Whitespace-only changes.

‎contrib/bit/varbit.h

Whitespace-only changes.

‎contrib/bit/varbit.source

Whitespace-only changes.

‎contrib/bit/varbit_glue.c

Whitespace-only changes.

‎contrib/bit/vartest.c

Whitespace-only changes.

‎contrib/datetime/Makefile

Whitespace-only changes.

‎contrib/datetime/README

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

‎contrib/datetime/datetime_functions.c

Whitespace-only changes.

‎contrib/datetime/datetime_functions.h

Whitespace-only changes.

‎contrib/datetime/datetime_functions.sql.in

Whitespace-only changes.

‎contrib/earthdistance/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/earthdistance/Makefile,v 1.3 2000/06/16 18:58:26 momjian Exp $
2+
# $Header: /cvsroot/pgsql/contrib/earthdistance/Makefile,v 1.4 2000/06/19 13:53:18 momjian Exp $
33
#
44

55
TOPDIR=../..
@@ -10,7 +10,7 @@ NAME= earthdistance
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/earthdistance/README

Lines changed: 0 additions & 31 deletions
Original file line numberDiff line numberDiff line change
@@ -1,31 +0,0 @@
1-
Date: Wed, 1 Apr 1998 15:19:32 -0600 (CST)
2-
From: Hal Snyder <hal@vailsys.com>
3-
To: vmehr@ctp.com
4-
Subject: [QUESTIONS] Re: Spatial data, R-Trees
5-
6-
> From: Vivek Mehra <vmehr@ctp.com>
7-
> Date: Wed, 1 Apr 1998 10:06:50 -0500
8-
9-
> Am just starting out with PostgreSQL and would like to learn more about
10-
> the spatial data handling ablilities of postgreSQL - in terms of using
11-
> R-tree indexes, user defined types, operators and functions.
12-
>
13-
> Would you be able to suggest where I could find some code and SQL to
14-
> look at to create these?
15-
16-
Here's the setup for adding an operator '<@>' to give distance in
17-
statute miles between two points on the earth's surface. Coordinates
18-
are in degrees. Points are taken as (longitude, latitude) and not vice
19-
versa as longitude is closer to the intuitive idea of x-axis and
20-
latitude to y-axis.
21-
22-
There's C source, Makefile for FreeBSD, and SQL for installing and
23-
testing the function.
24-
25-
Let me know if anything looks fishy!
26-
27-
A note on testing C extensions - it seems not enough to drop a function
28-
and re-create it - if I change a function, I have to stop and restart
29-
the backend for the new version to be seen. I guess it would be too
30-
messy to track which functions are added from a .so and do a dlclose
31-
when the last one is dropped.

‎contrib/earthdistance/earthdistance.sql

Whitespace-only changes.

‎contrib/findoidjoins/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/findoidjoins/Attic/Makefile,v 1.6 2000/06/16 18:58:29 momjian Exp $
2+
# $Header: /cvsroot/pgsql/contrib/findoidjoins/Attic/Makefile,v 1.7 2000/06/19 13:53:22 momjian Exp $
33
#
44

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

1111
PROGRAM=$(NAME)
1212
OBJS=$(NAME).o
13-
DOCS= README
13+
DOCS= README.$(NAME)
1414
SQLS=
1515
BINS =$(PROGRAM) make_oidjoins_check
1616
EXAMPLES=
@@ -31,7 +31,7 @@ install: install_doc nstall_bin
3131

3232
install_doc:
3333
forinst_filein$(DOCS);do \
34-
$(INSTALL)$(INSTL_LIB_OPTS)$$inst_file$(CONTRIB_DOCDIR)/$(DOCS).$(NAME);\
34+
$(INSTALL)$(INSTL_LIB_OPTS)$$inst_file$(CONTRIB_DOCDIR);\
3535
done
3636

3737
install_bin:

0 commit comments

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