On Wed, Dec 15, 2010 at 01:50:54PM -0600, Jack Christensen wrote: > 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. What happened here is that you ran into PostgreSQL's "charming" habit of using the argument.function notation, so you called the "name" function, i.e. the one that casts to name, on the entire row from your accounts table. Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
