- 15 3月, 2000 6 次提交
-
-
由 Tom Lane 提交于
so that the fmgr lookup only has to happen once per index scan and not once per tuple. Seems to save 5% or so of CPU time for an indexscan.
-
由 Thomas G. Lockhart 提交于
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.
-
由 Thomas G. Lockhart 提交于
-
由 Tom Lane 提交于
of BufferLocks[] entry just once. Seems to save 10% or so of the routine's runtime, which'd not be worth worrying about if it weren't such a hotspot.
-
由 Bruce Momjian 提交于
Please > apply the attached patch to > > backend/port/qnx4 > > Andreas Kardos >
-
由 Bruce Momjian 提交于
alpha_cc > template file. Patch attached. > > Andreas Kardos >
-
- 14 3月, 2000 5 次提交
-
-
由 Bruce Momjian 提交于
(Alpha). > > Andreas Kardos
-
由 Bruce Momjian 提交于
(Alpha). >
-
由 Bruce Momjian 提交于
Please > apply the attached patch. > > Andreas Kardos > >
-
由 Tatsuo Ishii 提交于
checking postmaster.pid. It's not enough to check the existence of postmaster.pid since DB recovery might be running.
-
由 Tom Lane 提交于
of tuples we are going to retrieve from a sub-SELECT. Must have been half asleep when I did this code the first time :-(
-
- 13 3月, 2000 7 次提交
-
-
由 Peter Eisentraut 提交于
psql script would be dropped silently.
-
由 Tom Lane 提交于
(ie, allow rounding to occur at a digit position left of the decimal point). Apparently this is how Oracle handles it, and there are precedents in other programming languages as well.
-
由 Tom Lane 提交于
Since we detect oversize tuples elsewhere, I see no reason not to allow string constants that are 'too long' --- after all, they might never get stored in a tuple at all.
-
由 Tom Lane 提交于
YY_READ_BUF_SIZE, which turns out to have nothing to do with buffer size. It's just a totally arbitrary upper limit on how much data myinput() is asked for at one time.
-
由 Tom Lane 提交于
set of SQL-standard type names that we accept.
-
由 Tom Lane 提交于
that the inputs to a given operator can be recursively simplified to constants, it was evaluating the operator using the op's *original* (unsimplified) arg list, so that any subexpressions had to be evaluated again. A constant subexpression at depth N got evaluated N times. Probably not very important in practical situations, but it made us look real slow in MySQL's 'crashme' test...
-
由 Tom Lane 提交于
fireRIRonSubselect was invoked twice at each subselect, leading to an exponential amount of wasted effort.
-
- 12 3月, 2000 4 次提交
-
-
由 Tom Lane 提交于
gone, replaced by plain a_expr. The few places where we needed to distinguish NULL from a_expr are now handled by tests inside the actions rather than by separate productions. This allows us to accept queries like 'SELECT 1 + NULL' without requiring parentheses around the NULL.
-
由 Tom Lane 提交于
subplan: do it if subplan has subplans itself, and always do it if the subplan is an indexscan. (I originally set it to materialize an indexscan only if the indexqual is fairly selective, but I dunno what I was thinking ... an unselective indexscan is still expensive ...)
-
由 Tom Lane 提交于
category STRING. Also, if UNKNOWNOID is passed in, return UNKNOWN_TYPE not USER_TYPE.
-
由 Tom Lane 提交于
coercion code. I'm beginning to wonder why we have separate candidate selection routines for functions, operators, and aggregates --- shouldn't this code all be unified? But meanwhile, SELECT 'a' LIKE 'a'; finally works; the code for dealing with unknown input types for operators was pretty busted.
-
- 11 3月, 2000 8 次提交
-
-
由 Peter Eisentraut 提交于
-
由 Tom Lane 提交于
subPlans to be considered 'simple'. This fixes reported problem with 'return exists (select 1 from foo);' in plpgsql function.
-
由 Tom Lane 提交于
per pghackers discussion around 20-Feb. Also add specific error messages for unterminated comments and unterminated quoted strings. These things are nonissues for input coming from psql, but they do matter for input coming from other front ends.
-
由 Tom Lane 提交于
about thread-safeness of the library.
-
由 Tom Lane 提交于
array. This allows processing of conninfo strings to be made thread-safe, at the cost of a small memory leak in applications that use PQconndefaults() and are not updated to free the returned array via the new PQconninfoFree() function. But PQconndefaults() is probably not used very much, so this seems like a good compromise.
-
由 Tom Lane 提交于
error message.
-
由 Peter Eisentraut 提交于
-
由 Marc G. Fournier 提交于
make sure that cvslog is workign right ... no changes but to remove a blank line
-
- 10 3月, 2000 4 次提交
-
-
由 Michael Meskes 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 09 3月, 2000 6 次提交
-
-
由 Peter Eisentraut 提交于
Some corrections in installation procedure
-
由 Michael Meskes 提交于
-
由 Tom Lane 提交于
nodes. The former version failed to check permissions of relations that were referenced in second and later clauses of UNIONs, and it did not check permissions of tables referenced via inheritance.
-
由 Hiroshi Inoue 提交于
They are #ifdef'd. Add -D_DROP_COLUMN_HACK__ compile option to evaluate it.
-
由 Tom Lane 提交于
freed wholesale by AllocSetReset() is overwritten too.
-
由 Tom Lane 提交于
VACUUM.
-