Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group