Sai Hertz And Control Systems wrote:
Dear Jan Wieck ,
Yes I agree with you Jan , most of the time we round the amount and
this is done by truncating greater than 3 decimal digits and
rounding the 3 digit to 2 in other words :
select trunc(1000.236897,3);
then
selecr round(1000.236,2);
This
Sai Hertz And Control Systems wrote:
Dear Jan Wieck ,
Floating point math itself is not precise, but rather an approximation,
usually of 8 or 14 digits. You can't approximate money. This isn't a
PostgreSQL issue but rather a general programming issue.
Thanks, Bruce. I assume the
Michael Glaesemann wrote:
On Jan 4, 2004, at 6:51 PM, Bruce Momjian wrote:
Michael Glaesemann wrote:
On Dec 29, 2003, at 11:28 AM, Sai Hertz And Control Systems wrote:
I would like to share my concerns about the IEEE 754 specification
and
floating point handling by PostgreSQL .
What specifically
Sai Hertz And Control Systems wrote:
Dear all ,
I would like to share my concerns about the IEEE 754 specification and
floating point handling by PostgreSQL .
Also I would like to learn how professional users of PostgreSQL work
with rounding of monetary terms .
For all monetary values the P
Nicolas Nolst wrote:
[text/html is unsupported, treating like TEXT/PLAIN]
> [...]
> My problem is that populating my database is slower when the data gets
>bigger and the performance falls dramatically. I thought that is would be improve
>with my indexes but the problem still persists.
> Could
Bruce Momjian wrote:
> > Larry Rosenman <[EMAIL PROTECTED]> writes:
> > > FYI, the WU-FTPD code (2.6.0 or better) has a couple of more platforms
> > > including UnixWare. The UnixWare code will need /dev/kmem permission to
> > > change it's stuff, so I don't know whether we want to do this or not
Peter Eisentraut wrote:
> Wallingford, Ted writes:
>
> > I am using 6.3 in this case.
>
> I'm sorry but that is pre-historic era around here and no one really
> remembers what the problems might have been back then (other than that
> they were surely plenty). Upgrading might be your best bet on al
build the
required shared object and use that.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#===== [EMAIL PROTECTED] (Jan Wieck) #
Interested?
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#= [EMAIL PROTECTED] (Jan Wieck) #
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#= [EMAIL PROTECTED] (Jan Wieck) #
ght want to grab 'em out of
that and try if they build AND RUN with v6.3.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#= [EMAIL PROTECTED] (Jan Wieck) #
ard. If the user is
already authenticated by Apache, why let PostgreSQL check the
password again?
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#= [EMAIL PROTECTED] (Jan Wieck) #
ing wrong than for being right. #
# Let's break this rule - forgive me. #
#===== [EMAIL PROTECTED] (Jan Wieck) #
me. #
#= [EMAIL PROTECTED] (Jan Wieck) #
.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
# [EMAIL PROTECTED] (Jan Wieck) #
ond is omitted.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======== [EMAIL PROTECTED] (Jan Wieck) #
think that's worth the efford.
Jan
--
#==========#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
# [EMAIL PROTECTED] (Jan Wieck) #
re anything else I need todo to install plpgsql.
Which version of PostgreSQL?
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
# [EMAIL PROTECTED] (Jan Wieck) #
.
BTW: I love regular expressions [:-]
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
# [EMAIL PROTECTED] (Jan Wieck) #
ll me on +49-40-5395-1404 (yepp -
Hamburg) and we'll do it together.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.
pg_id from the commandline?
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======== [EMAIL PROTECTED] (Jan Wieck) #
=#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======== [EMAIL PROTECTED] (Jan Wieck) #
familiar enough with parsetree's to fix things in them,
you're welcome.
Jan
--
#==========#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
# [EMAIL PROTECTED] (Jan Wieck) #
=#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
# [EMAIL PROTECTED] (Jan Wieck) #
t isn't available.
So folks, low level HP/UX 10.10 know how required!
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
# [EMAIL PROTECTED] (Jan Wieck) #
=#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
# [EMAIL PROTECTED] (Jan Wieck) #
to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======== [EMAIL PROTECTED] (Jan Wieck) #
rgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======== [EMAIL PROTECTED] (Jan Wieck) #
og indices isn't allowed.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======== [EMAIL PROTECTED] (Jan Wieck) #
t forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
# [EMAIL PROTECTED] (Jan Wieck) #
to that before connecting
will do it.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======== [EMAIL PROTECTED] (Jan Wieck) #
ubdirectory.
I could send you the latest versions if you can't cvsup.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
# [EMAIL PROTECTED] (Jan Wieck) #
32 matches
Mail list logo
