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

Re: [GENERAL] Can || be used in ORDER BY?

From: Jose Soares <jose(at)sferacarta(dot)com>
To: Jeremy Malcolm <Jeremy(at)malcolm(dot)wattle(dot)id(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Can || be used in ORDER BY?
Date: 2000-01-26 13:29:32
Message-ID: 388EF6BC.DED8B067@sferacarta.com (view raw or flat)
Thread:
Lists: pgsql-general
create table tablename ( field1 text, field2 text);
CREATE
insert into tablename values('bottom','yes');
INSERT 2282464 1
insert into tablename values('top','no');
INSERT 2282465 1
select field1,field2 from tablename order by (field1||'-top');

field1|field2
------+------
bottom|yes
top   |no
(2 rows)


José


Jeremy Malcolm wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
>
> I would like to do this:
>
>                         select
>                         field1,field2
>                         from tablename
>                         order by (field1||'-top')
>
> ie. order the records by the contents of field1 with the text "-top"
> concatenated to it.  It doesn't work, I get a parse error.
>
> Can anyone offer advice?
>
> Thanks.
>
> - --
> JEREMY MALCOLM Jeremy(at)Malcolm(dot)wattle(dot)id(dot)au http://malcolm.wattle.id.au
> SIG of the day: [ ] Contact  [ ] Web  [ ] PGP  [ ] Taglines #1  [x] #2
> "I'm a lawyer." "Honest?" "No, the usual kind." | Linux, the choice of
> a GNU generation. | Are you the brain specialist? | "Could anyone pass
> the sodium chloride, please?" - Adric (5W) | The Nanites have lawyers?
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.0.2i
>
> iQB1AwUBOI3a6L/mBljD2JABAQG3RQL8DxUkukKGm7jEa9rSgyFzXMcd5KJejRxU
> abscA8SuVq7ENXdFncx+5OsAk0VQfzBkUkRlobD9LEFXm6aTsK2zqmlhdVsJFKyh
> f/YOixdaGiNzE+9xfIpEz+iizzKBwPRy
> =bED8
> -----END PGP SIGNATURE-----
>
> ************

In response to

Responses

pgsql-general by date

Next:From: Jeremy MalcolmDate: 2000-01-26 13:43:54
Subject: RE: [GENERAL] Can || be used in ORDER BY?
Previous:From: Donald DadeDate: 2000-01-26 12:14:29
Subject: Creating groups and granting privs to it

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