- 27 6月, 2003 3 次提交
-
-
由 Bruce Momjian 提交于
> * Improve performance for queries with many columns
-
由 Tom Lane 提交于
comparison functions), replacing the highly bogus bitwise array_eq. Create a btree index opclass for ANYARRAY --- it is now possible to create indexes on array columns. Arrange to cache the results of catalog lookups across multiple array operations, instead of repeating the lookups on every call. Add string_to_array and array_to_string functions. Remove singleton_array, array_accum, array_assign, and array_subscript functions, since these were for proof-of-concept and not intended to become supported functions. Minor adjustments to behavior in some corner cases with empty or zero-dimensional arrays. Joe Conway (with some editorializing by Tom Lane).
-
由 Tom Lane 提交于
-
- 26 6月, 2003 22 次提交
-
-
由 Michael Meskes 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> * Create improved PostgreSQL introductory documentation for the PHP > manuals (Rory)
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> * Allow the identifier length to be increased via a configure option
-
由 Bruce Momjian 提交于
> * Promote debug_query_string into a server-side function current_query()
-
由 Bruce Momjian 提交于
not ready yet.
-
由 Bruce Momjian 提交于
Joe Conway
-
由 Tom Lane 提交于
HH:MM:SS.SSS... when there is a nonzero part-of-a-day field in an interval value. The seconds part used to be suppressed if zero, but there's no equivalent behavior for timestamp, and since we're modeling this format on timestamp it's probably wrong. Per complaint and patch from Larry Rosenman.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
This is no longer necessary or appropriate since we don't use zero typeid as a wildcard anymore, and it fixes a nasty performance problem with functions with many parameters. Per recent example from Reuven Lerner.
-
由 Tom Lane 提交于
-
由 Michael Meskes 提交于
-
由 Michael Meskes 提交于
-
- 25 6月, 2003 15 次提交
-
-
由 Bruce Momjian 提交于
-
由 Michael Meskes 提交于
-
由 Michael Meskes 提交于
-
由 Bruce Momjian 提交于
The attached fixes select_common_type() to support the below case: create table t1( c1 int); create domain dom_c1 int; create table t2(c1 dom_c1); select * from t1 join t2 using( c1 ); I didn't see a need for maintaining the domain as the preferred type. A simple getBaseType() call on all elements of the list seems to be enough. -- Rod Taylor <rbt@rbt.ca>
-
由 Bruce Momjian 提交于
> * -Allow CIDR format to be used in pg_hba.conf
-
由 Bruce Momjian 提交于
> * -Allow UPDATE to use SET col = DEFAULT
-
由 Bruce Momjian 提交于
Rod Taylor
-
由 Bruce Momjian 提交于
after the CHECK. Cluster depends on the index name, so I thought it wise to ensure all names are available, rather than leaving off the CONSTRAINT "$n" portion for internally named constraints. CREATE TABLE jkey (col integer primary key); CREATE TABLE j (col integer REFERENCES jkey); ALTER TABLE j ADD CHECK(col > 5); This is a problem in 7.3 series as well as -Tip. Rod Taylor <rbt@rbt.ca>
-
由 Bruce Momjian 提交于
pg_get_constraintdef() for >= 70400. Rod Taylor <rbt@rbt.ca>
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
- LIKE <subtable> [ INCLUDING DEFAULTS | EXCLUDING DEFAULTS ] - Quick cleanup of analyze.c function prototypes. - New non-reserved keywords (INCLUDING, EXCLUDING, DEFAULTS), SQL 200X Opted not to extend for check constraints at this time. As per the definition that it's user defined columns, OIDs are NOT inherited. Doc and Source patches attached. -- Rod Taylor <rbt@rbt.ca>
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> * Allow creation of a libpq-only tarball >
-
由 Bruce Momjian 提交于
incompatible. I believe the attached xref meets the intent of the perform.sgml change. -- Rod Taylor <rbt@rbt.ca>
-