Re: [BUGS] dividing money by money

2010-04-05 Thread Chris Browne
to...@tuxteam.de writes: > On Fri, Apr 02, 2010 at 10:18:24AM -0700, Chris Travers wrote: > >> Suppose I live in Canada and I have two checking accounts for my >> business, one in CAD and one in USD. In essence I have to account for >> a floating balance of a foreign currency [...] >>

Re: [BUGS] dividing money by money

2010-04-05 Thread Chris Travers
Hi Chris, Many thanks for your comments. On Mon, Apr 5, 2010 at 10:16 AM, Chris Browne wrote: > Indeed. > > You can only be certain of there actually being a conversion if the > transaction directly involved a conversion between currencies. > > Thus... > >  1. If I buy materials using $USD on t

Re: [BUGS] dividing money by money

2010-04-05 Thread John R Pierce
Chris Travers wrote: Hmm... Back to the drawing board on that helper module :-). like I said, its a big tarpit. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] dividing money by money

2010-04-05 Thread Kevin Grittner
John R Pierce wrote: > Chris Travers wrote: >> Hmm... Back to the drawing board on that helper module :-). > > like I said, its a big tarpit. If you start up on this again, you might want to start a new thread with a more descriptive subject. Those who weren't interested in Andy's issue might

Re: [BUGS] dividing money by money

2010-04-05 Thread Robert Haas
On Mon, Apr 5, 2010 at 4:37 PM, Kevin Grittner wrote: > John R Pierce wrote: >> Chris Travers wrote: >>> Hmm... Back to the drawing board on that helper module :-). >> >> like I said, its a big tarpit. > > If you start up on this again, you might want to start a new thread > with a more descripti

[BUGS] regexp_matches illegally restricts rows

2010-04-05 Thread Josh Berkus
Severity: major (data loss) Versions Tested: 8.4.2, 9.0 HEAD Test Case: create table regex_test ( id serial not null primary key, myname text ); insert into regex_test ( myname ) values ( 'josh'),('joe'),('mary'),('stephen'), ('jose'), ('kelley'),('alejandro'); select id, regexp_matches(myname,

[BUGS] Re: regexp_matches illegally restricts rows -- just a documentation issue?

2010-04-05 Thread Josh Berkus
On 4/5/10 9:16 PM, Josh Berkus wrote: > I can't see how this is anything but a bug; as far as I know, nothing in > the target list is allowed to restrict the number of rows which are > returned by the query. We should get 7 rows, 3 of which have an empty > array or a NULL in the 2nd column. Just