More on Order by

From: lsunley(at)mb(dot)sympatico(dot)ca
To: pgsql-hackers(at)PostgreSQL(dot)org
Subject: More on Order by
Date: 2004-12-26 19:57:08
Message-ID: 0I9C0092UL2I9P@l-daemon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi All

I have discovered that when I use a table like this

create table whois (acol name);

and insert a few rows, the order by clause works correctly.

I dug into the database init stuff to find that the table pg_class column
relname is where the pg_tables column tablename comes from. That column is
defined as a 'name' datatype.

So what is difference between a "name" and a char(10)???

Lorne

--
-----------------------------------------------------------
lsunley(at)mb(dot)sympatico(dot)ca
-----------------------------------------------------------

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message lsunley 2004-12-26 20:13:36 Problem with ORDER BY
Previous Message Bruce Momjian 2004-12-26 16:48:44 Re: Where do pg_hba.conf include files live?