[BUGS] BUG #5403: Missing left parenthesis.

2010-04-02 Thread Andrey.S.Alexeenko
The following bug has been logged online: Bug reference: 5403 Logged by: Andrey.S.Alexeenko Email address: rastamanc...@mail.ru PostgreSQL version: 8.4.2 Operating system: FreeBSD 7.2 Description:Missing left parenthesis. Details: [r...@genesis /home/ss25]# psql -U

Re: [BUGS] BUG #5403: Missing left parenthesis.

2010-04-02 Thread Craig Ringer
On 2/04/2010 7:34 PM, Andrey.S.Alexeenko wrote: The following bug has been logged online: Bug reference: 5403 Logged by: Andrey.S.Alexeenko Email address: rastamanc...@mail.ru PostgreSQL version: 8.4.2 Operating system: FreeBSD 7.2 Description:Missing left parenthes

Re: [BUGS] BUG #5403: Missing left parenthesis.

2010-04-02 Thread Tom Lane
"Andrey.S.Alexeenko" writes: > library=> SELECT '978-5-699-00691-5'::isbn::text; > ERROR: malformed record literal: "978-5-699-00691-5" > LINE 1: SELECT '978-5-699-00691-5'::isbn::text; >^ > DETAIL: Missing left parenthesis. I can replicate the above if I create a table (not a d

Re: [BUGS] UTF-8 encoding failure

2010-04-02 Thread Hiroshi Saito
Hi Martin-san. I prepared the environment which was alike in order to reproduce your problem. And a very comfortable result is obtained. http://winpg.jp/~saito/PGSQL_SJIS/InternationalVersionWindows/ Probably some of Japanese language setup is lacking. Regards, Hiroshi Saito - Original Mes

Re: [BUGS] dividing money by money

2010-04-02 Thread Dimitri Fontaine
Chris Travers writes: > Ok. Here is my application: I write a multi-currency accounting > program backed by PostgreSQL. After 1.3 is released (2Q this year), > we expect to be doing a full redesign. > > What I am thinking about is having a custom data type, something like: I'd be interested in

Re: [BUGS] dividing money by money

2010-04-02 Thread Chris Travers
On Fri, Apr 2, 2010 at 9:51 AM, Dimitri Fontaine wrote: >> One could also then store monetary[] arrays for addressing specific >> denomination storage.  I.e. "When closing the till we had 26 pennies, >> 53 nickles, 12 quarters, 25 $1 bills, 35 $5 bills, 15 $10 bills, and 5 >> $20 bills." >> >> Th

Re: [BUGS] dividing money by money

2010-04-02 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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 [...]