Re: More on Order by - Mailing list pgsql-hackers

From lsunley@mb.sympatico.ca
Subject Re: More on Order by
Date
Msg-id 0I9C0093CM0R8M@l-daemon
Whole thread Raw
In response to Re: More on Order by  (Michael Fuhr <mike@fuhr.org>)
List pgsql-hackers
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 <20041226211640.GA28590@winnie.fuhr.org>, on 12/26/04   at 02:16 PM, Michael Fuhr <mike@fuhr.org> said:

>On Sun, Dec 26, 2004 at 02:57:08PM -0500, lsunley@mb.sympatico.ca 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 is not intended for use by the general user."



-- 
-----------------------------------------------------------
lsunley@mb.sympatico.ca
-----------------------------------------------------------



pgsql-hackers by date:

Previous
From: lsunley@mb.sympatico.ca
Date:
Subject: Problem with ORDER BY
Next
From: lsunley@mb.sympatico.ca
Date:
Subject: more on character fields