Re: Trapping 'invalid input syntax for integer'

From: Mario Splivalo <mario(dot)splivalo(at)megafon(dot)hr>
To: Marcin Krawczyk <jankes(dot)mk(at)gmail(dot)com>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Trapping 'invalid input syntax for integer'
Date: 2009-09-10 14:13:22
Message-ID: 4AA90982.1070002@megafon.hr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Thnx, that is it.

Mike

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rob Sargent 2009-09-10 16:32:40 Re: how to: refer to select list calculations other places in the calculations.
Previous Message Marcin Krawczyk 2009-09-10 13:54:47 Re: Trapping 'invalid input syntax for integer'