Re: Custom column ordering - Mailing list pgsql-general

From Emre Hasegeli
Subject Re: Custom column ordering
Date
Msg-id CAE2gYzzoDo4jT0ioQYepcwdxOJoUe5xP7-wK5uYEYSWnBRNr_A@mail.gmail.com
Whole thread Raw
In response to Re: Custom column ordering  (Steven Xu <stevenx@yorku.ca>)
Responses Re: Custom column ordering  (Steven Xu <stevenx@yorku.ca>)
List pgsql-general
> Although, I do find your output very strange. You wrote ORDER BY port, which
> is a text type. Why does Postgres order using the ordering operators of the
> "Port" data type rather than the "text" type, even though you haven't
> performed a cast?

That is an editing mistake.  I mean

> hasegeli=# SELECT port FROM device_port ORDER BY cast_to_port(port);


pgsql-general by date:

Previous
From: "David Bennett"
Date:
Subject: Re: Does a call to a language handler provide a context/session, and somewhere to keep session data?
Next
From: Geoff Winkless
Date:
Subject: Re: index problems (again)