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

2012-09-01 Thread Johan Nel
"Chris Travers" wrote in message news:CAKt_ZfvZfYq_VPYXG3p=fy=s1whcc0p9trxkczfrrsjsqms...@mail.gmail.com... On Fri, Aug 31, 2012 at 12:25 PM, Andy Yoder wrote: Hello all, I would like the community's input on a topic. The words "too far out of the mainstream" are from an e-mai

Re: [GENERAL] Estimated rows question

2012-09-01 Thread Tom Lane
[ sorry for slow response, but I'd not gotten time to think about this... ] Sam Ross writes: > I was wondering why it seems that the query planner can't "see", based > on the histograms, that two join-columns have a very small > intersection, and adjust its row estimation accordingly. The reason

Re: [GENERAL] CASE/WHEN behavior with NULLS

2012-09-01 Thread Thalis Kalfigkopoulos
On Sat, Sep 1, 2012 at 6:19 AM, David Johnston wrote: > On Aug 31, 2012, at 22:49, Tom Lane wrote: > >> David Johnston writes: >>> On Aug 31, 2012, at 21:52, Tom Lane wrote: David Johnston writes: > That said you might want to try > SUM(COALESCE(foo, 0)) >> Actually I'd go wi

Re: [HACKERS] [GENERAL] Date conversion using day of week

2012-09-01 Thread Bruce Momjian
[Properly posted to hackers list] On Fri, Apr 1, 2011 at 02:27:02AM +1100, Brendan Jurd wrote: > On 1 April 2011 02:00, Adrian Klaver wrote: > > On Wednesday, March 30, 2011 8:39:25 pm Brendan Jurd wrote: > >> If we wanted to make it "work", then I think the thing to do would be > >> to add a ne

Re: [HACKERS] [GENERAL] Date conversion using day of week

2012-09-01 Thread Bruce Momjian
On Fri, Apr 1, 2011 at 03:58:48AM +1100, Brendan Jurd wrote: > On 1 April 2011 03:32, Adrian Klaver wrote: > > Now I am confused the docs say: > > > > D       day of the week, Sunday(1) to Saturday(7) > > ID      ISO day of the week, Monday(1) to Sunday(7) > > > > This would seem to say they both

Re: [HACKERS] [GENERAL] Date conversion using day of week

2012-09-01 Thread Bruce Momjian
On Fri, Apr 1, 2011 at 02:27:02AM +1100, Brendan Jurd wrote: > On 1 April 2011 02:00, Adrian Klaver wrote: > > On Wednesday, March 30, 2011 8:39:25 pm Brendan Jurd wrote: > >> If we wanted to make it "work", then I think the thing to do would be > >> to add a new set of formatting tokens IDY, IDA

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

2012-09-01 Thread Stefan Kaltenbrunner
On 09/01/2012 01:24 PM, Peter Bex wrote: > On Sat, Sep 01, 2012 at 12:43:15AM +0200, Geert Mak wrote: >> There is this case studies section as well - >> >> http://www.postgresql.org/about/casestudies/ >> >> Which appear to me a little old and a little too little, one could try to >> add more, perh

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

2012-09-01 Thread Pavel Stehule
2012/9/1 Chris Travers : > > > On Fri, Aug 31, 2012 at 12:25 PM, Andy Yoder wrote: >> >> Hello all, >> >> I would like the community's input on a topic. The words "too far out of >> the mainstream" are from an e-mail we received from one of our clients, >> describing the concern our client's IT g

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

2012-09-01 Thread Pavel Stehule
2012/9/1 Tom Lane : > 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 > >> Pretty sure that's not true. I

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

2012-09-01 Thread Scott Marlowe
On Sat, Sep 1, 2012 at 9: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 > >> Pr

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

2012-09-01 Thread Tom Lane
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 > Pretty sure that's not true. Ingres is a cousin of Postgres s

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

2012-09-01 Thread Chris Travers
On Sat, Sep 1, 2012 at 7:45 AM, Scott Marlowe wrote: > 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 > > Pretty sure that's not

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

2012-09-01 Thread Scott Marlowe
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 Pretty sure that's not true. Ingres is a cousin of Postgres started by the same guy, Ston

Re: [GENERAL] Getting random rows from a table

2012-09-01 Thread Raymond O'Donnell
On 01/09/2012 05:23, Gurjeet Singh wrote: > This email has been sitting in my drafts folder since Sept 20th, 2008. > Almost 4 years! Getting it off my chest now. I am attaching 2 files for > this solution I developed, because I don't know which is the correct one Better later than never! :-) One f

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

2012-09-01 Thread Chris Travers
Wandering away from the original topic a little but helpful enough to continue this line of reasoning here. On Sat, Sep 1, 2012 at 5:42 AM, Edson Richter wrote: > >> It's an interesting thing. > We have a product that runs over PostgreSQL without any problems (well, we > have few, but most of th

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

2012-09-01 Thread David Boreham
On 9/1/2012 6:42 AM, Edson Richter wrote: Nevertheless, when we present our product to customers, they won't get satisfied until we guarantee we can run same product with major paid versions (Oracle, MS SQL, and so on). I think this is a business problem not a technology problem. Forget trying

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

2012-09-01 Thread Chris Travers
On Fri, Aug 31, 2012 at 12:25 PM, Andy Yoder wrote: > Hello all, > > I would like the community's input on a topic. The words "too far out of > the mainstream" are from an e-mail we received from one of our clients, > describing the concern our client's IT group has about our use of > PostgreSQL

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

2012-09-01 Thread Edson Richter
Em 31/08/2012 16:52, David Johnston escreveu: -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of Andy Yoder Sent: Friday, August 31, 2012 3:25 PM To: pgsql-general@postgresql.org Cc: Andy Yoder Subject: [GENERAL] "Too far

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

2012-09-01 Thread Peter Bex
On Sat, Sep 01, 2012 at 12:43:15AM +0200, Geert Mak wrote: > There is this case studies section as well - > > http://www.postgresql.org/about/casestudies/ > > Which appear to me a little old and a little too little, one could try to add > more, perhaps. I noticed that the "Share Your Story" lin

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

2012-09-01 Thread Dean Rasheed
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, Aug 30, 2012 at 6:31 PM,