Re: Difference Between record and rowtype

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Difference Between record and rowtype
Date: 2006-08-11 12:33:16
Message-ID: 7410.1155299596@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Sabino Mullane 2006-08-11 12:51:55 Re: libpq Describe Extension [WAS: Bytea and perl]
Previous Message Paul Silveira 2006-08-11 12:23:25 snapshot replication with pg_dump