Re: More on Order by

From: lsunley(at)mb(dot)sympatico(dot)ca
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: More on Order by
Date: 2004-12-26 20:21:14
Message-ID: 0I9C0093CM0R8M@l-daemon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)GA28590(at)winnie(dot)fuhr(dot)org>, on 12/26/04
at 02:16 PM, Michael Fuhr <mike(at)fuhr(dot)org> said:

>On Sun, Dec 26, 2004 at 02:57:08PM -0500, lsunley(at)mb(dot)sympatico(dot)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(at)mb(dot)sympatico(dot)ca
-----------------------------------------------------------

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message lsunley 2004-12-26 20:49:25 more on character fields
Previous Message lsunley 2004-12-26 20:13:36 Problem with ORDER BY