[ too tired to respond to the other points, but: ] Shay Rojansky <r...@roji.org> writes: >> It's also possible for a type not to have send/recv functions, i.e. to >> support text-only use.
> In that case, what would be the behavior of selecting such a type with an > extended query that specifies "all results in binary"? A PG error? Yup. if (!OidIsValid(pt->typsend)) ereport(ERROR, (errcode(ERRCODE_UNDEFINED_FUNCTION), errmsg("no binary output function available for type %s", format_type_be(type)))); There's an exactly parallel error if you try to send a parameter in binary when its datatype hasn't got a typreceive function. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers