FORTRAN Interface Notes: 8/2/93
---------------------------------------

   o The ROWS_AFFECTED parameter of GDI_SUBMIT no longer tells you how 
     many records are actually available. It sounded like a good idea at
     the time, but I have to "fetch all" into the portal.  The larger the
     dataset, the longer it takes to return the MAXREC rows you requested.

     The MORE_DATA parameter will still tell you if there are more data; 
     however, there is no way you can know how much more data unless you 
     have done a query to count the results.

   o 2D arrays work, but you have to be careful how you declare the FORTRAN 
     variables for containing Postgres results.  The following extracts are
     from the test routine gdi_f77_array.f.  INDKEY is an oid28 in the 
     system catalogs. INDCLASS is an oid8.

      INTEGER*2     INDKEY (8,10)
                            ^---------------------------+
      INTEGER*4     INDCLASS (8,10)                     |
                              ^------ the array dimension must be first
                                      and must match GDI_ADD_MAP_FIELD.
                                                        |
      STATUS = GDI_ADD_MAP_FIELD(DBCONN, MAP_ID,        |
     +     'indkey', INDKEY, GDI_INT2, 0, 8)  <---------+
      IF (STATUS .NE. GDI_SUCCESS) THEN                 |
         GOTO 999                                       |
      END IF                                            |
                                                        |
      STATUS = GDI_ADD_MAP_FIELD(DBCONN, MAP_ID,        |
     +     'indclass', INDCLASS, GDI_INT4, 0, 8) <------+
      IF (STATUS .NE. GDI_SUCCESS) THEN
         GOTO 999
      END IF

   o Undimensioned numeric arrays are implemented but have not been tested
     in FORTRAN yet.  Theoretically, the gdi should hand back no more data
     that you have requested with GDI_ADD_MAP_FIELD.

   o Arrays of strings, including undimensioned arrays of strings, have not 
     been tested in FORTRAN yet.

