What is the name pseudo column

From: Jack Christensen <jackc(at)hylesanderson(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: What is the name pseudo column
Date: 2010-12-15 19:50:54
Message-ID: 4D091C1E.2040607@hylesanderson.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I was just surprised when accidentally selecting a non-existent name
column there was no error -- instead something came back.

select accounts.name from accounts limit 1 ->
(1,65522,1,0.00,,"2010-07-22 09:57:26.281172-05",2)

It appears it tries to return the entire row in an array (but longer
rows get truncated).

I've searched Google and the PG docs but I haven't had any luck.

--
Jack Christensen
jackc(at)hylesanderson(dot)edu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus Moor 2010-12-15 19:55:24 Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
Previous Message Alban Hertroys 2010-12-15 19:10:04 Re: Is possible to use Prepare/Execute inside a function?