Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id A0E6D4761B2
	for <pgsql-sql@postgresql.org>; Mon,  7 Oct 2002 19:01:54 -0400 (EDT)
Received: from trill.maridan.net (unknown [217.6.52.210])
	by postgresql.org (Postfix) with ESMTP id 42CA7475EAE
	for <pgsql-sql@postgresql.org>; Mon,  7 Oct 2002 19:01:48 -0400 (EDT)
Received: from rafcio.polonium.de (130-149-145-107.dialup.cs.tu-berlin.de
	[130.149.145.107])
	by trill.maridan.net (8.9.3/8.9.3) with ESMTP id BAA25441
	for <pgsql-sql@postgresql.org>; Tue, 8 Oct 2002 01:01:49 +0200
Message-Id: <5.1.0.14.0.20021008005744.01f1a2c8@mail.polonium.de>
X-Sender: rafcio@mail.polonium.de
X-Mailer: QUALCOMM Windows Eudora Version 5.1
Date: Tue, 08 Oct 2002 01:01:10 +0200
To: pgsql-sql@postgresql.org
From: Rafal Kedziorski <rafcio@polonium.de>
Subject: Debug information
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/95
X-Sequence-Number: 9813

Hallo,

I'm working on porting Oracle schema to PostgreSQL. Now I habe the whole 
schema in PostgreSQL. But there are some problems in our application in 
some sql queries. I get following errors.

ERROR:  Unable to identify an operator '<=' for types 'numeric' and 'double 
precision'
         You will have to retype this query using an explicit cast

Its possible to display the queries in debug print out ftom PostgreSQL with 
queries which failed? If yep, how?


Best Regards,
Rafal