binary size of each pgsphere's datatype

[g.broc...@gmail.com]

Hi all,

I'm interested to know if all datatype defined in pgsphere (spoint, ecc.) have a fixed binary size or not. I mean, could they be considered as varlena datatype?

Regards,
Giuseppe.

[mnul...@ari.uni-heidelberg.de]

Hi Giuseppe,

> I'm interested to know if all datatype defined in pgsphere (spoint,
> ecc.) have a fixed binary size or not.

Most of them have, except for spoly and spath.

> I mean, could they be considered as varlena datatype?

Yes, spoly and spath are variable-length. For reference,
here are the relevant lines from pgs_types.sql.in :

CREATE TYPE spoint (
internallength = 16,
CREATE TYPE strans (
internallength = 32,
CREATE TYPE scircle (
internallength = 24,
CREATE TYPE sline (
internallength = 32,
CREATE TYPE sellipse (
internallength = 40,
CREATE TYPE spoly (
internallength = VARIABLE,
CREATE TYPE spath (
internallength = VARIABLE,
CREATE TYPE sbox (
internallength = 32,

Best regards,
Markus