Re: Create lo Data type

"A  Mohan" <abmohan75@rediffmail.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