"Ron Peterson" <ron.peterson@xxxxxxxxxxxxxx> writes: > 2007-10-13_08:50:56-0400 Ron Peterson <ron.peterson@xxxxxxxxxxxxxx>: >> 2007-10-13_01:22:06-0400 Gregory Stark <stark@xxxxxxxxxxxxxxxx>: > >> > And normally you would define your own datatype and not use bytea. >> >> Actually, I already have my data in a structure much like varlena. > > Pght, I misunderstood what you were saying. You mean create a > full-blown new type. I was thinking completely internally. Yeah, > that's probably a better approach - I'll do that. Or you could just define new functions which operate on bytea if you're just storing binary data. I don't understand what you mean with "internally" if you're storing this in tuples? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match