From: | Chris Travers <chris(dot)travers(at)gmail(dot)com> |
---|---|
To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | strange behavior, hoping for an explanation |
Date: | 2011-11-11 06:56:35 |
Message-ID: | CAKt_Zfu18vu3X4+VC7ooH_v1rrB7oEqATNp5zC8AS26R6Tr6nQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi;
I have found recently that tables in certain contexts seem to have a
name pseudocolumn. I was wondering if there is any documentation as
to what this is and what it signifies.
postgres=# CREATE table TEST2 (a text, b text);
CREATE TABLE
postgres=# INSERT INTO test2 values ('aaaa', 'bbbb');
INSERT 0 1
postgres=# select t.name FROM test2 t;
name
-------------
(aaaa,bbbb)
(1 row)
However:
postgres=# select name FROM test2 t;
ERROR: column "name" does not exist
LINE 1: select name FROM test2 t;
This isn't making any sense to me. Are there certain circumstances
where a tuple is cast to something like varchar(63)? Does this pose
pitfals for any columns named 'name' in other contexts?
Best Wishes,
Chris Travers
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-11-11 07:11:20 | Re: strange behavior, hoping for an explanation |
Previous Message | Tom Lane | 2011-11-11 03:50:18 | Re: Fedora 16 note... |