Re: [GENERAL] Postgresql problem with update double precision

2011-08-05 Thread Chris Travers
On Fri, Aug 5, 2011 at 7:32 AM, Igor Neyman wrote: > If you want to avoid your problem, switch to NUMERIC(precision, scale), which > is precise data type. > Alter the type of your "double" columns. > I'd suggest NUMERIC without specifying precision or scale. That gives you the most flexibility.

Re: [GENERAL] Postgresql problem with update double precision

2011-08-05 Thread Igor Neyman
> -Original Message- > From: Condor [mailto:con...@stz-bg.com] > Sent: Friday, August 05, 2011 6:49 AM > To: pgsql-general@postgresql.org > Subject: Postgresql problem with update double precision > > > Hello ppl, > for few years I have problem when update double precision field. I have

Re: [GENERAL] Postgresql problem with update double precision

2011-08-05 Thread Condor
On Fri, 05 Aug 2011 07:20:01 -0400, Jerry Sievers wrote: Condor writes: Hello ppl, for few years I have problem when update double precision field. I have table and few double precision columns, here is example: sumall double precision, sumin double precision, My php script do: $get = 2.40

Re: [GENERAL] Postgresql problem with update double precision

2011-08-05 Thread Jerry Sievers
Condor writes: > Hello ppl, > for few years I have problem when update double precision field. I > have table and few double precision columns, here is example: > > sumall double precision, > sumin double precision, > > My php script do: > > $get = 2.40 > > and sql code is: > > UPDATE table1 SET

[GENERAL] Postgresql problem with update double precision

2011-08-05 Thread Condor
Hello ppl, for few years I have problem when update double precision field. I have table and few double precision columns, here is example: sumall double precision, sumin double precision, My php script do: $get = 2.40 and sql code is: UPDATE table1 SET sumall = sumall + $get WHERE id = 1

Re: [GENERAL] postgreSQL problem

2010-09-01 Thread John R Pierce
On 09/01/10 7:40 PM, Scott Marlowe wrote: On Wed, Sep 1, 2010 at 3:52 PM, John R Pierce wrote: however, that user shouldn't show up on the "Welcome" friendly style login screen.OTOH, I'm not sure what mechanism is used to prevent this. ah, a little googling... on 32bit windows.. registry

Re: [GENERAL] postgreSQL problem

2010-09-01 Thread Scott Marlowe
On Wed, Sep 1, 2010 at 3:52 PM, John R Pierce wrote: > however, that user shouldn't show up on the "Welcome" friendly style login > screen.    OTOH, I'm not sure what mechanism is used to prevent this. > > ah, a little googling... on 32bit windows.. registry entry > > HKEY_LOCAL_MACHINE\SOFTWARE\M

Re: [GENERAL] postgreSQL problem

2010-09-01 Thread John R Pierce
On 09/01/10 2:01 PM, Alvaro Herrera wrote: Excerpts from Luka Novak's message of mié sep 01 06:35:13 -0400 2010: hello! I just recently installed PostgreSQL for my HoldemManager application, and after a restart, there was actually a new windows user account named postgre on the startup along

Re: [GENERAL] postgreSQL problem

2010-09-01 Thread Alvaro Herrera
Excerpts from Luka Novak's message of mié sep 01 06:35:13 -0400 2010: > hello! > > > I just recently installed PostgreSQL for my HoldemManager application, and > after a restart, there was actually a new windows user account named postgre > on the startup along with my admin account for windows (

[GENERAL] postgreSQL problem

2010-09-01 Thread Luka Novak
hello! I just recently installed PostgreSQL for my HoldemManager application, and after a restart, there was actually a new windows user account named postgre on the startup along with my admin account for windows (if i didnt make it clear -- the account to log in to windows, before windows start

[GENERAL] PostgreSQL problem with functions

2001-06-12 Thread Nikola Milutinovic
Hi all. Maybe this is not such a novice question, but I'm having problem subscribin to some more "professional" PG lists. Here goes... I'm trying to make a function in PostgreSQL v7.0. Right now, I'm bugging with PL/PgSQL and SQL functions. What I want to achieve is: "insert new row in a table