Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id D129C632A26
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 10 Sep 2009 11:13:37 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 45507-05 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 10 Sep 2009 14:13:29 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from megafon.hr (megafon.hr [213.202.104.5])
	by mail.postgresql.org (Postfix) with ESMTP id 24F77632A01
	for <pgsql-sql@postgresql.org>; Thu, 10 Sep 2009 11:13:30 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by megafon.hr (Postfix) with ESMTP id 8C1922500DA;
	Thu, 10 Sep 2009 16:13:27 +0200 (CEST)
X-Virus-Scanned: ClamAV at megafon.hr
Received: from megafon.hr ([127.0.0.1])
	by localhost (localhost.localdomain [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id MVF2SoZ1w0im; Thu, 10 Sep 2009 16:13:22 +0200 (CEST)
Received: from [192.168.1.94] (localhost.localdomain [127.0.0.1])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested) (Authenticated sender: mike)
	by megafon.hr (Postfix) with ESMTPSA id 9A245250124;
	Thu, 10 Sep 2009 16:13:22 +0200 (CEST)
Message-ID: <4AA90982.1070002@megafon.hr>
Date: Thu, 10 Sep 2009 16:13:22 +0200
From: Mario Splivalo <mario.splivalo@megafon.hr>
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
MIME-Version: 1.0
To: Marcin Krawczyk <jankes.mk@gmail.com>
CC: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Re: Trapping 'invalid input syntax for integer'
References: <4AA8EFAB.8070509@megafon.hr>
	<95f6bf9b0909100654p3b5e31b3nb6174b3482eb51b3@mail.gmail.com>
In-Reply-To: <95f6bf9b0909100654p3b5e31b3nb6174b3482eb51b3@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.74 tagged_above=-10 required=5 tests=BAYES_20=-0.74
X-Spam-Level: 
X-Archive-Number: 200909/42
X-Sequence-Number: 33107

Marcin Krawczyk wrote:
> Hi, I believe you're looking for invalid_text_representation.
> 
> EXCEPTION WHEN invalid_text_representation THEN
> 

Thnx, that is it.

	Mike