Subject: [PATCHES] port patch: ultrix4

ultrix4 doesn't compile without this.  this also fixes a problem
with dynamic loading (ultrix relocatable objects must be loaded
with -G 0).

Subject: [PATCHES] Three small patches.

Hi,

Here are 3 small patches to the postgreSQL source sup'd on
the 6th May 1997.

The 1st 2 fix the shell backslash "c" handling used to suppress
the newline on some unix shells. (The \c needs to be inside quote.)

The 3rd may or may not be the correct way to fix the missing
define of INDEX_MAX_KEYS in pg_dump.h

Subject: [PATCHES] oracle_compat functions core dumping on NULL-fields

return if storage is not allocated. Ref: Vadim 97/05/01

No real change in the support code is required since the actual size
 of the structures is calculated using offsetof() rather than sizeof().

 case-insensitive SQL parser.

 with case-insensitive SQL parser.

 by case-insensitive SQL parser.

 in case-insensitive SQL. Define LOread() and LOwrite() as macros
 to avoid having to update calls everywhere.

2. Fix for function indices with more than 1 attrs.

    fd = FileNameOpenFile(path, O_RDWR|O_CREAT|O_EXCL, 0600);

    /*
     *  If the file already exists and is empty, we pretend that the
     *  create succeeded.  During bootstrap processing, we skip that check,
     *  because pg_time, pg_variable, and pg_log get created before their
     *  .bki file entries are processed.
     *
>    *  As the result of this pretence it was possible to have in
>    *  pg_class > 1 records with the same relname. Actually, it
>    *  should be fixed in upper levels, too, but... -  vadim 05/06/97
>    */

Assert ( --Vnpages > 0 );
	and
Assert ( --Fnpages > 0 );

	changed to
WARN:parser: syntax error ...

when btree used in innerscan with run-time key which value
passed by pointer.

Fix: keys ordering stuff moved to _bt_first().

Pointed by Thomas Lockhart.

if 1st bucket chain is empty then need to continue scan in the rest buckets.

Modified a few tests to match results on RedHat Linux/gcc for v6.1beta.

bool _use_geqo_ = true;
#else
bool _use_geqo_ = false;
#endif

_use_geqo_ is settable via SET var TO ...

in target list.

From: Lee Roth <roth@tpusa.com>

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.