Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Can || be used in ORDER BY? - Mailing list pgsql-general

From Jose Soares
Subject Re: [GENERAL] Can || be used in ORDER BY?
Date
Msg-id 388EF6BC.DED8B067@sferacarta.com
Whole thread Raw
In response to Can || be used in ORDER BY?  ("Jeremy Malcolm" <Jeremy@Malcolm.wattle.id.au>)
Responses RE: [GENERAL] Can || be used in ORDER BY?  ("Jeremy Malcolm" <Jeremy@Malcolm.wattle.id.au>)
List pgsql-general
Tree view
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@Malcolm.wattle.id.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-----

************

pgsql-general by date:

Previous
From: Dirk Lutzebaeck
Date:
Subject: Re: [GENERAL]COPY still running
Next
From: "Jeremy Malcolm"
Date:
Subject: RE: [GENERAL] Can || be used in ORDER BY?