Is this a bug in 7.0.2

From: Steven Vajdic <svajdic(at)asc(dot)corp(dot)mot(dot)com>
To: pgsql-bugs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)oeg
Subject: Is this a bug in 7.0.2
Date: 2001-04-04 03:58:35
Message-ID: 3ACA9BEA.A2769097@asc.corp.mot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers


Dear all,

I've migrated from RedHat6.2/PHP3.0/PostgreSQL6.5 to
Mandrake/PHP4.0/Postgres7.0.2 successfully as far as
pg_dump database_name is concerned.

I am still running BOTH versions on two computers.

PostgreSQL6.5 does not produce any error using math function "integer
(float_expression)"
(even "int(float_expression" is OK with 6.5)
and 7.0.2 complains saying:

"function integer(float8) is not found for specified types"

The query is used in something like this:

SELECT
attr-1,
attr-2,

...

attr-k,
integer(attr-2 * $php_variable_1 + atrr-3 * $php_variable_2) AS attr-N

FROM
table_1, table_2
WHERE
clause_1 AND
clause_2
ORDER BY
attr-2, attr-4

If I made an error HERE with the sintax, I apologise - I am not close to
my both Linux machines,
and sintax is OK in my real SELECT queries.

"$php_xxx"s are PHP variables and "attr-xxx"s are SQL table attributes.
The "integer(float_expression)"
is more complicated then written above BUT it all DOES work in 6.5 and
DOES NOT in 7.0.2.

Any ideas, please?

Much obliged,

Steven.

--
***********************************************

Steven Vajdic (BSc/Hon, MSc)
Senior Software Engineer
Motorola Australia Software Centre (MASC)
2 Second Avenue, Technology Park
Adelaide, South Australia 5095
email: Steven(dot)Vajdic(at)motorola(dot)com
email: svajdic(at)asc(dot)corp(dot)mot(dot)com
Ph.: +61-8-8168-3435
Fax: +61-8-8168-3501
Front Office (Ph): +61-8-8168-3500

----------------------------------------
mobile: +61 (0)419 860 903
AFTER WORK email: steven_vajdic(at)ivillage(dot)com
----------------------------------------

***********************************************

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-04-04 04:31:27 Re: Table constraint ordering disrupted by pg_dump
Previous Message Philip Warner 2001-04-04 02:37:09 Re: Table constraint ordering disrupted by pg_dump

Browse pgsql-hackers by date

  From Date Subject
Next Message Adriaan Joubert 2001-04-04 05:14:47 Re: Final call for platform testing
Previous Message Nathan Myers 2001-04-04 00:54:05 Re: Re: Final call for platform testing