On Wed, Jul 16, 2003 at 11:41:06 -0500,
Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Wed, Jul 16, 2003 at 12:48:26 +0100,
> Gary Stainburn <[EMAIL PROTECTED]> wrote:
> > Hi folks,
> >
> > I've got a table holding loco numbers and an id which references the locos
> > table. How can I sort t
On Wed, Jul 16, 2003 at 12:48:26 +0100,
Gary Stainburn <[EMAIL PROTECTED]> wrote:
> Hi folks,
>
> I've got a table holding loco numbers and an id which references the locos
> table. How can I sort this table, so that numeric values appear first in
> numerical order followed by alpha in alpha o
On Wednesday 16 July 2003 3:27 pm, Dmitry Tkach wrote:
> Gary Stainburn wrote:
> >Hi folks,
> >
> >I've got a table holding loco numbers and an id which references the locos
> >table. How can I sort this table, so that numeric values appear first in
> >numerical order followed by alpha in alpha ord
Gary Stainburn wrote:
Hi folks,
I've got a table holding loco numbers and an id which references the locos
table. How can I sort this table, so that numeric values appear first in
numerical order followed by alpha in alpha order.?
What about
select lnid,lnumber,lncurrent from
(select *, cas
Hi folks,
I've got a table holding loco numbers and an id which references the locos
table. How can I sort this table, so that numeric values appear first in
numerical order followed by alpha in alpha order.?
nymr=# \d lnumbers
Table "lnumbers"
Column | Type
