More on Order by - Mailing list pgsql-hackers

From lsunley@mb.sympatico.ca
Subject More on Order by
Date
Msg-id 0I9C0092UL2I9P@l-daemon
Whole thread Raw
Responses Re: More on Order by
List 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@mb.sympatico.ca
-----------------------------------------------------------



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Where do pg_hba.conf include files live?
Next
From: Michael Fuhr
Date:
Subject: Re: More on Order by