New types in binary ?

We are developping a GIS system using PG as database.

We could create multiple geographic type in PG: point, line, polygon,... but
we would like to try something else.

We want to use this structure in creating a new PG type (extending PG type
in C)

typedef struct {
int4 size; /* for postgresql and us */
int4 type; /* The type of object NONE, POINT, etc. */
float8 bound[2][3]; /* bounding box -- min(x,y,z) max(x,y,z) */
char data[1]; /* Resizable variable type data */
} geoobj;

The geobj->data would contain the binary representation of various
structures:

typedef struct {
int4 type=1;
float x,y,z
} point

typedef struct {
int4 type=2;
float x1,y1,z1,x2,y2,z2;
} line

and so on...

We could write functions that will convert the various structures into an
ascii stream for display in PG:

select geoobj from table
"POINT [x,y,z]" , "LINE [x1,y1,z1][x2,y2,z2]"

But we would like also the data pushed in pure binary. We could use a
function to ensure we want the binary value of the type

Select XDR(geoobj) from table
<binarystuff>

We will then take the binary stuff stored in a char and we will cast it to
the right structure. Do you think it will work and PG will not jump to the
roof because of binary stream output as a char* ?

BTW it will create a varbinary type that is waiting to be toasted.

Cheers.

Franck Martin
Database Development Officer
SOPAC South Pacific Applied Geoscience Commission
Fiji
E-mail: franck(at)sopac(dot)org(dot)fj <mailto:franck(at)sopac(dot)org(dot)fj>
Web site: http://www.sopac.org.fj/ <http://www.sopac.org.fj/>