| 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: | Whole Thread | Raw Message | 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... |