public inbox for [email protected]
help / color / mirror / Atom feedFrom: Greg Smith <[email protected]>
To: [email protected]
Subject: Special column trivia
Date: Sun, 06 Jun 2010 03:18:57 -0400
Message-ID: <[email protected]> (raw)
I was just reading
http://www.postgresql.org/docs/9.0/static/ddl-system-columns.html and
noted that the second part about the ctid being unstable: "a row's ctid
will change if it is updated or moved by VACUUM FULL" is probably not
true anymore. Is that worth updating?
What got me reading that section was a rather weird documentation
question/addition from Edmund Horner. He noted that the following works
on PG8.4 and 9.0:
postgres=# select (row(1,2)).name;
name
-------
(1,2)
Having not worked on earlier versions (this from 8.3):
postgres=# select (row(1,2)).name;
ERROR: could not identify column "name" in record data type
I didn't see anything that documents the ability to use "name" to refer
to the composite record like this. Since it's not an area of the code
I'm familiar with, so I'm just baffled as Edmund. "Row Constructors" at
http://www.postgresql.org/docs/current/interactive/sql-expressions.html
and "Composite Value Input" at
http://www.postgresql.org/docs/current/interactive/rowtypes.html both
seem relevant, but don't seem to explain what's happening. That second
one is where he pointed out confusion can really creep in, because
"name" is also a field in the inventory_item table, which makes it
particularly easy for a coding error to refer to the wrong thing oddly.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
[email protected] www.2ndQuadrant.us
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Special column trivia
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox