Re: Create lo Data type

"A Mohan" <abmohan75(at)rediffmail(dot)com> writes:
> To create lo type we gave the following SQL.
> CREATE TYPE lo (
> internallength=4, externallength=10,
> input=int4in, output=int4out,
> default='', passedbyvalue
> );

> But we could not create this lo type.

You can't cheat like that anymore in defining a type. You have to
provide real I/O functions for it.

A more appropriate way to define LO in 7.3 is as a domain:

CREATE DOMAIN lo AS int4;

(although actually I'd think it should be a domain of OID not INT4).

regards, tom lane