I was moving a small database I had from 7.0.3 to 7.1beta3 using pgdump
and had a problem with a view. The I got a syntax error when the rule
corresponding to the view was being processed. While looking around I
noticed that the dump file created a table with the name of the view
instead of creati
A problem I reported a few weeks ago here using to_char to do a conversion
to roman numerals with many of the values being null doesn't seem to be
a problem in 7.1beta3.
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 c
