Re: [GENERAL] C locale versus en_US.UTF8. (Was: String comparision in PostgreSQL)

2012-09-02 Thread Peter Eisentraut
On Wed, 2012-08-29 at 10:31 -0700, Aleksey Tsalolikhin wrote: > What is the difference between C and en_US.UTF8, please? There are many differences, but here is a simple one: $ (echo a; echo A; echo b; echo B) | LC_ALL=C sort A B a b $ (echo a; echo A; echo b; echo B) | LC_ALL=en_US.utf8 sort a A

Re: [GENERAL] fast-archiver tool, useful for pgsql DB backups

2012-09-02 Thread Peter Eisentraut
On Fri, 2012-08-24 at 15:48 -0600, Mathieu Fenniak wrote: > Hi pgsql-general, > > Has anyone else ever noticed how slow it can be to rsync or tar a pgdata > directory with hundreds of thousands or millions of files? Yes: http://petereisentraut.blogspot.com/2012/05/base-backup-compression-options.

[GENERAL] RE: [GENERAL] UPDATE RULE to be invoked when UPDATE .. WHERE fails the WHERE predicate ?‏

2012-09-02 Thread johnlumby
On 09/01/12 03:46, Dean Rasheed wrote: On 31 August 2012 16:32, John Lumby wrote: ___ From: pavan.deola...@gmail.com Date: Fri, 31 Aug 2012 11:09:42 +0530 Subject: Re: [GENERAL] UPDATE RULE to be invoked when UPDATE .. WHERE fails the WHERE predicate ?‏ On Thu, Au

[GENERAL]

2012-09-02 Thread Steve Haresnape
/subscribe-set pgsql-general digest/ -- Steve Haresnape Creative Integrity Ltd 68 Te Kawa Road, Greenlane, Auckland 1061 s.haresn...@creativeintegrity.co.nz Phone: 09 579 6328 Mobile: 021 514 666 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscr

Re: [GENERAL] Naming conventions

2012-09-02 Thread Bruce Momjian
On Fri, May 25, 2012 at 09:49:18AM +0100, Raymond O'Donnell wrote: > On 25/05/2012 02:21, Bruce Momjian wrote: > > On Wed, May 16, 2012 at 10:08:03AM +0100, Raymond O'Donnell wrote: > >> On 15/05/2012 22:50, Scott Briggs wrote: > >>> So this is purely anecdotal but I'm curious, what's with all the

Re: [GENERAL] CASE/WHEN behavior with NULLS

2012-09-02 Thread Craig Ringer
On 09/01/2012 02:07 PM, Thalis Kalfigkopoulos wrote: Thanks all for the replies. Actually I had already tested that sum() behaved correctly with respect to NULLs, meaning that it ignored them (or treated them as 0, couldn't really tell). That's why I went ahead sum()ing even though I knew NULLs w

Re: [GENERAL] GRANT SELECT

2012-09-02 Thread Jasen Betts
On 2012-08-27, Stephen Crawford wrote: > Is there a simple way to grant SELECT privileges to a user for all the > tables in a database, without having to do it for each table? grant the role (membership of) a role that already has the priveleges. -- ⚂⚃ 100% natural -- Sent via pgsql-gener

[GENERAL] Re: C locale versus en_US.UTF8. (Was: String comparision in PostgreSQL)

2012-09-02 Thread Jasen Betts
On 2012-08-29, Bruce Momjian wrote: >> Name | Owner | Encoding | Collate |Ctype| >> Access privileges >> --+--+---+-+-+--- >> clocale_utf8 | smarlowe | UTF8 | C | en_US.UTF-8 | >> >>

Re: [GENERAL] CASE/WHEN behavior with NULLS

2012-09-02 Thread Jasen Betts
On 2012-09-01, Chris Angelico wrote: > On Sat, Sep 1, 2012 at 12:07 PM, David Johnston wrote: >> These are not equivalent if some values of foo are not-null and you want the >> sum of all non-null values while replacing any nulls with zero. So the >> decision depends on what and why you are su

Re: [GENERAL] "Too far out of the mainstream"

2012-09-02 Thread Chris Travers
On Sat, Sep 1, 2012 at 8:01 AM, Tom Lane wrote: > Scott Marlowe writes: > > On Sat, Sep 1, 2012 at 7:25 AM, Chris Travers > wrote: > >> 1) While MySQL is perhaps better marketed, PostgreSQL is an older > project > >> with a proud heritage (Informix started as a Postgres fork), and > top-rate >