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

possible 7.1beta3 bug with union and order by a function

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql-bugs(at)postgresql(dot)org
Subject: possible 7.1beta3 bug with union and order by a function
Date: 2001-01-10 07:34:23
Message-ID: 20010110013423.A28293@wolff.to (view raw or flat)
Thread:
Lists: pgsql-bugs
The query below used to work with 7.0.3. If I change 'lower(title)' to
'title' in the order by clause, then the query is accepted.

area=> select code, wbc.gameid, title from games, wbc where wbc.gameid = games.gameid union select code, null, null as title from wbc where gameid is null order by code, lower(title);
ERROR:  Attribute 'title' not found

Responses

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2001-01-10 16:04:30
Subject: JDBC Connection must be restarted after executing SQL statement that calls a PL/PGSQL function that won't compile
Previous:From: Bruno Wolff IIIDate: 2001-01-10 05:10:54
Subject: to_char appears fixed in 7.1beta3

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