Port Bug Report: byte order problem on Inter and SGI

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Wen Jiang
Your email address : wj691781(at)bcm(dot)tmc(dot)edu

Category : runtime: front-end: C++
Severity : non-critical

Summary: byte order problem on Inter and SGI

System Configuration
--------------------
Operating System : RedHat 5.2 i386 and SGI Irix 6.5

PostgreSQL version : 6.4.2

Compiler used : g++

Hardware:
---------

Versions of other tools:
------------------------

--------------------------------------------------------------------------

Problem Description:
--------------------
I setup backend on Redhat 5.2 on a PC, and C++ frontend on linux
and SGI, the testlibpq5 program worked correctly, but the
sgi version has wrong byte order for the binary cursor.

--------------------------------------------------------------------------

Test Case:
----------
results from PC frontend/PC backend:
tuple 0: got
i = (4 bytes) 1,
d = (4 bytes) 3.567,
p = (4 bytes) 2 points boundbox = (hi=3/4,lo = 1,2)
tuple 1: got
i = (4 bytes) 2,
d = (4 bytes) 89.05,
p = (4 bytes) 2 points boundbox = (hi=4/3,lo = 2,1)

results from SGI frontend/PC backend:
tuple 0: got
i = (4 bytes) 16777216,
d = (4 bytes) -0.000768248,
p = (4 bytes) 33554432 points boundbox = (hi=0e-321/0e-321,lo = 0e-320,0e-323)
tuple 1: got
i = (4 bytes) 33554432,
d = (4 bytes) -3.17837e-23,

--------------------------------------------------------------------------

Solution:
---------

--------------------------------------------------------------------------