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

Re: weird problem with PG 8.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marcin Krol <mrkafk(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: weird problem with PG 8.1
Date: 2009-03-31 15:50:46
Message-ID: 11043.1238514646@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Marcin Krol <mrkafk(at)gmail(dot)com> writes:
> When I issue:
> SELECT * FROM virtualization;

> I get all the fields:

> reservations=# SELECT * FROM virtualization;
>   id | Virtualization  |  color
> ----+-----------------+---------

> But when I try to order by column Virtualization:
> reservations=# SELECT * FROM virtualization ORDER BY Virtualization;

You need

	SELECT * FROM virtualization ORDER BY "Virtualization";

What you typed is a request to sort by the composite row value,
which isn't supported in any pre-8.4 release.

You might care to go re-read the manual about identifier quoting
and case folding.

			regards, tom lane

In response to

pgsql-general by date

Next:From: David E. WheelerDate: 2009-03-31 15:56:32
Subject: Re: [HACKERS] string_to_array with empty input
Previous:From: Osvaldo KussamaDate: 2009-03-31 15:50:30
Subject: Re: weird problem with PG 8.1

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