Subject: [HACKERS] Inputting money

I notice that I have to put single quotes around money amounts if there
is a decimal point in the value.  I appears to be happening because there
is something changing things like "123.45" to "123.450000" and the code
has a problem with that.  There may be a better way to fix this but here
is a simple change to cash.c that lets it accept trailing zeroes.

Add a little info on count().

Add mixed-case #define synonyms to avoid changing more source code.
Add comparison operators for boolean.
Add aggregate min() and max() for datetime and timespan.

Add comparison operators for boolean.
Add aggregate min() and max() for datetime and timespan.
Fix duplicate OID in pg_proc.h

Add comparison operators to boolean and smaller/larger operators to datetime
and timespan. Fix int4 overflow math problem in timespan comparison operators.

Subject: [PATCHES] to make regress.sh shell friendly to echo.

Hi,

I needed to make the following change to regress.sh to make it more
shell friendly.

The Solaris /bin/sh, and others, use \c to supress the newline.

what's being tested :)

Pointed out by: Christopher Hicks <chicks@chicks.net>

the DROP TABLE calls from the destroy.sql file to the 'types' .sql files,
so that they are self-contained

btree_index, hash_index and misc all fail as there seems to be missing
a 'misc.out' expected file...have asked Thomas for one...

=============== destroying old regression database... =================
=============== creating new regression database...   =================
=============== running regression queries...         =================
create_function_1 .. ok
create_type .. ok
create_table .. ok
create_function_2 .. ok

that are created should only exist as long as the test requires them...

things are just toooooo spread around

debugging is a little (well, alot!) easier

away from one big massive confusing file

Pointed out by: adrian@waltham.harvard.net

do this completely last time and Thomas is creating patches on files that
aren't supposed to exist :(

Remove bin/Makefile.global since it wasn't actually *doing* anything
that Makefile.global hadn't already done

Here are patches which should help fix timezone problems in the
datetime and abstime code. Also, I repatched varlena.c to add in
some comments and a little error checking on top of Vadim's earlier
repairs. There are slight mods to the circle data type to have the
distance operator between circles measure the distance between
closest points rather than between centers.

Subject: [PATCHES] Patches for compiling 6.1 on Digital Unix 3.2c

Attached to this message are the patches I needed to compile 6.1 cleanly
under Digital Unix 3.2c with DEC cc.

I hope these are the last ones. At least, the number of files needing a
patch has decreased noticeably since I sent my previous patches. Nice work
:-)

One of the patches is a bug fix, but I'm including it here anyway.

With these patches applied, the beast seems to work properly. However,
I've done only some preliminary tests. More on this later (but hopefully
before the April 30 deadline... :-)

postgres backend processes end up as so called zombies. It seems that
only Linux a.out (libc.4.6.27) systems are affected.


By:

Wolfgang Roth <roth@statistik.uni-mannheim.de>

Doug Neuhauser <doug@seismo.berkeley.edu> on April 15th

Added #define BTREE_VERSION_1.

     * npages = index_pages * selectivity_of_1st_attr_clause(s)

joininfo (in add_join_clause_info_to_rels()) : clause may be
commutted later.

nestloop's join clauses doesn't work in some cases:
         *    1. fix_indxqual_references may change varattno-s in
         *       inner_indxqual;
         *    2. clauses may be commuted