Hi Scott,
Scott Marlowe wrote:
Sorry, I mentioned the wrong operator before, it's ~>~ and ~<~ (asc
versus desc):
smarlowe=# create table col_test (a text);
CREATE TABLE
smarlowe=# insert into col_test (a) values ('"quoted"'),('Abc'),('123');
INSERT 0 3
smarlowe=# select * from col_test order by
On Thu, Sep 18, 2008 at 10:35 PM, Joe <[EMAIL PROTECTED]> wrote:
> Hi Scott,
>
> Scott Marlowe wrote:
>>
>> no, not encoding, locale, such as en_US or C determine sort order.
>>
>
> OK, so I guess you're saying that whatever was in the LC_COLLATE environment
> variable at the time the template0 dat
Joe wrote:
Thanks for the info. The hosting company already offers 8.3
databases. It's just that other things (we use tsearch2) have taken
precedence over migrating to 8.3. How can I tell if the patch you
mention is installed?
As admin (or somebody with shell access) by running "pg_config
Joe wrote:
I guess that means the encoding of the respective template0 database is
what determines the sort order (UTF8 on FreeBSD and LATIN1 on Debian),
right? Unfortunately, I'm unable to change the FreeBSD cluster since
it's shared with others at our hosting provider. Is there some way t
Hi Scott,
Scott Marlowe wrote:
no, not encoding, locale, such as en_US or C determine sort order.
OK, so I guess you're saying that whatever was in the LC_COLLATE
environment variable at the time the template0 database was created
determines the collation/sort order? Is that stored and v
On Thu, Sep 18, 2008 at 6:48 PM, Joe <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I just found that two identical queries on two PG 8.2.7 databases with the
> same data and same encoding, one running on Debian and the other on FreeBSD,
> returned rows in a different order, even though both queries had an O
Hi,
I just found that two identical queries on two PG 8.2.7 databases with
the same data and same encoding, one running on Debian and the other on
FreeBSD, returned rows in a different order, even though both queries
had an ORDER BY clause. Essentially, on FreeBSD a varchar starting with
a d