Re: Difference Between record and rowtype - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Difference Between record and rowtype
Date
Msg-id 7410.1155299596@sss.pgh.pa.us
Whole thread Raw
In response to Difference Between record and rowtype  (Volkan YAZICI <yazicivo@ttnet.net.tr>)
List pgsql-hackers
Volkan YAZICI <yazicivo@ttnet.net.tr> writes:
> What's [the difference between] a record (which is a pseudo 'p' type) and
> a rowtype (which's a complex 'c' type).

The main difference is that you can't declare a table column as having
a pseudotype.  RECORD is restricted to uses where the system can
determine the specific row type from context, whereas a 'c' type is
effectively self-contained and will work anywhere.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Paul Silveira
Date:
Subject: snapshot replication with pg_dump
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: libpq Describe Extension [WAS: Bytea and perl]