Postgres Pro
Downloads
Home   >   mailing lists

Re: transaction problem using cursors - Mailing list pgsql-general

From Pit M.
Subject Re: transaction problem using cursors
Date
Msg-id f4jhts$k8a$1@news.hub.org
Whole thread Raw
In response to Re: transaction problem using cursors  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Responses Re: transaction problem using cursors  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 

Pavel Stehule schrieb:
> Hello
>
> I thing so problem is there
>
>                    AND Cast("CUSTOMERS"."ZIP" as integer) < 20000
>
> You cannot cast 'A1234' to integer
>
> Regards
> Pavel Stehule
>


Yes i know that i can't, but why the transaction fails?

Pit

pgsql-general by date:

Previous
From: "Alexander Staubo"
Date:
Subject: Re: Distributing PostGres database to various customers
Next
From: "Pavel Stehule"
Date:
Subject: Re: transaction problem using cursors