[HACKERS] More on Order by

2004-12-26 Thread lsunley
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

Re: [HACKERS] More on Order by

2004-12-26 Thread Michael Fuhr
On Sun, Dec 26, 2004 at 02:57:08PM -0500, [EMAIL PROTECTED] wrote: So what is difference between a name and a char(10)??? See the Character Types section in the Data Types chapter of the documentation. The name type exists _only_ for storage of identifiers in the internal system catalogs and

Re: [HACKERS] More on Order by

2004-12-26 Thread lsunley
OK I believe that.. But why does order by work on a name column but not a char(10) column. See my earlier (posted later because of problems) e-mail. Lorne In [EMAIL PROTECTED], on 12/26/04 at 02:16 PM, Michael Fuhr [EMAIL PROTECTED] said: On Sun, Dec 26, 2004 at 02:57:08PM -0500, [EMAIL