Re: [BUGS] order by question.

2007-05-04 Thread Ennio-Sr
* Jose Blanco <[EMAIL PROTECTED]> [040507, 14:28]: > This second time I did, see > > select author, sort_author from itemsbyauthor where sort_author like 'tan%' > order by 2; > > > "order by 2" > > Or am I not understanding something? Hi Jose, have you tried to modify your query as others sugg

Re: [BUGS] order by question.

2007-05-04 Thread Ennio-Sr
* Ennio-Sr <[EMAIL PROTECTED]> [040507, 23:52]: > * Jose Blanco <[EMAIL PROTECTED]> [040507, 14:28]: > > This second time I did, see > > > > select author, sort_author from itemsbyauthor where sort_author like 'tan%' > > order by 2; > > >

[BUGS] Psql 'Expanded display (\x)' behaviour

2003-04-04 Thread Ennio-Sr
Hello! I'm new to this list and hope it is the right one (I posted to General and Novice but got no answer). I know that issues concerning the (erroneously) so called extended ASCII chars are of partial interest to English speaking people ... so I should be very grateful if any of you could confir

Re: [BUGS] Psql 'Expanded display (\x)' behaviour

2003-04-05 Thread Ennio-Sr
> Ennio-Sr writes: > > > toggling on/off the 'Expanded display' (in psql) does affect the display > > of non-ascii chars. > > Not at all. It's only an alternative table format. Yes, but when I try to display this 'alternative table format' I fou

Re: [BUGS] pg_dump silently fails

2005-06-14 Thread Ennio-Sr
* Bruce Momjian [140605, 14:00]: > Tom Lane wrote: > > Brandon Keepers <[EMAIL PROTECTED]> writes: > > > I've been wresting with this problem since 8.0.1 and am able to > > > duplicate it on 6 different installations. If I compile postgres from > > > source, everything works fine. If I install t