Re: [BUGS] BUG #1889: little documentation error

2005-09-17 Thread Tom Lane
"Evgeny Gridasov" <[EMAIL PROTECTED]> writes: > see the text: > To define a tablespace, use the CREATE DATABASE command, for example: > CREATE TABLESPACE fastspace LOCATION '/mnt/sda1/postgresql/data'; > i guess the text should be "use the CREATE TABLESPACE" command =) Yup --- thanks for catchi

[BUGS] BUG #1889: little documentation error

2005-09-17 Thread Evgeny Gridasov
The following bug has been logged online: Bug reference: 1889 Logged by: Evgeny Gridasov Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: n/a Description:little documentation error Details: http://developer.postgresql.org/docs/postgres/mana

Re: [BUGS] BUG #1888: bug in cast from float4 to float8

2005-09-17 Thread Michael Fuhr
On Sat, Sep 17, 2005 at 04:00:50AM +0100, Pablo Oses wrote: > select cast(123.456::float4 as float8) > > what do you think its the answer ? 123.456 ? > > well pgsql 7.2.2, 8.0.0, 8.0.1 and 8.0.3 (all i have used) answers this: > 123.456001281738 which is WRONG Float4 has a precision of only abou

Re: [BUGS] BUG #1888: bug in cast from float4 to float8

2005-09-17 Thread Tom Lane
"Pablo Oses" <[EMAIL PROTECTED]> writes: > select cast(123.456::float4 as float8) > what do you think its the answer ? 123.456 ? > well pgsql 7.2.2, 8.0.0, 8.0.1 and 8.0.3 (all i have used) answers this: > 123.456001281738 which is WRONG This is not a bug. Please go learn something about floati

Re: [BUGS] BUG #1886: Bug in SQL parsing

2005-09-17 Thread Pete Beck
Well spotted! :-) It looks like the bug must actually be with Hibernate, which generated the offending code. I'll take it up with those guys. Thanks for your help! Pete Stephan Szabo wrote: On Fri, 16 Sep 2005, Pete Beck wrote: The following bug has been logged online: Bug reference:

[BUGS] BUG #1888: bug in cast from float4 to float8

2005-09-17 Thread Pablo Oses
The following bug has been logged online: Bug reference: 1888 Logged by: Pablo Oses Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.x and 7.2.x Operating system: redhat, slackware and win32 Description:bug in cast from float4 to float8 Details: this is *rea