Search Postgresql Archives

Re: transaction problem using cursors

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: transaction problem using cursors
From: "Pit M." <fmi-soft@xxxxxx>
Date: Mon, 11 Jun 2007 15:15:56 +0200
In-reply-to: <162867790706110459x4e3d74dbyf13f4e7b9857cda8@xxxxxxxxxxxxxx>
Organization: Hub.Org Networking Services
References: <f4jck1$7fh$1@xxxxxxxxxxxx> <162867790706110459x4e3d74dbyf13f4e7b9857cda8@xxxxxxxxxxxxxx>
User-agent: Thunderbird 1.5.0.12 (Windows/20070509)



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: transaction problem using cursors
  - From: Pavel Stehule

References:
- transaction problem using cursors
  - From: Pit M.
- Re: transaction problem using cursors
  - From: Pavel Stehule

Prev by Date: Re: Distributing PostGres database to various customers
Next by Date: Re: transaction problem using cursors
Previous by thread: Re: transaction problem using cursors
Next by thread: Re: transaction problem using cursors
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux