[BUGS] "ORDER BY" issue - is this a bug?

2000-09-10 Thread Max Pyziur
Greetings, I've been using postgresql for some time and currently am using it in three different environments (specific details below) w/ the first two being 6.5.x releases and the third 7.0.2-2: I've come across what I consider an odd sorting anomaly in 7.0.2-2 where running the following que

Re: [BUGS] "ORDER BY" issue - is this a bug?

2000-09-10 Thread Tom Lane
Max Pyziur <[EMAIL PROTECTED]> writes: > I've come across what I consider an odd sorting anomaly in 7.0.2-2 where running > the following query: > select headline from headlines where headline like 'Alb%' order by 1 ; > The results in the 7.0.2-2 install come back case-insensitive and > oblivious

Re: [BUGS] "ORDER BY" issue - is this a bug?

2000-09-10 Thread Max Pyziur
Tom Lane wrote: > > Max Pyziur <[EMAIL PROTECTED]> writes: > > I've come across what I consider an odd sorting anomaly in 7.0.2-2 where running > > the following query: > > select headline from headlines where headline like 'Alb%' order by 1 ; > > > The results in the 7.0.2-2 install come back c

Re: [BUGS] "ORDER BY" issue - is this a bug?

2000-09-10 Thread Tom Lane
Max Pyziur <[EMAIL PROTECTED]> writes: >> That's pretty bizarre (not to say difficult to believe). What LOCALE >> setting are you running the postmaster in? > On none of the installations - the two 6.5.x and the 7.0.2-2 one - I > don't have any locale set. I get (what I think are) correct resul

Re: [SQL] Re: [BUGS] "ORDER BY" issue - is this a bug?

2000-09-10 Thread Max Pyziur
Tom Lane wrote: > > Max Pyziur <[EMAIL PROTECTED]> writes: > >> That's pretty bizarre (not to say difficult to believe). What LOCALE > >> setting are you running the postmaster in? > > > On none of the installations - the two 6.5.x and the 7.0.2-2 one - I > > don't have any locale set. I get (

Re: [BUGS] How to connect to a remote database

2000-09-10 Thread Vasileiadis Spyros
USE: psql -h -p -u psql -h -p -U -W read the man page SV - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 07, 2000 2:21 PM Subject: [BUGS] How to connect to a remote database > Martin Kuria ([EMAIL PROTECTED]) reports a bug with

Re: [BUGS] How to connect to a remote database

2000-09-10 Thread Sean Kelly
On Thu, 7 Sep 2000 07:21:57 -0400 (EDT), [EMAIL PROTECTED] said: > Martin Kuria ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > How to connect to a remote database > > Long Description > This may be a dumb ques