Re: [SQL] PostgreSQL - ERROR: Cannot cast type character varying to

2005-07-12 Thread Christoph Haller
Under PostgreSQL 7.3 it was necessary to use an intermediate cast to text when converting from varchar to int4. sum( unidades::text::int4 ) should do. Regards, Christoph Mauricio Fernandez wrote: > > Hello I´m new in the list, and I want to learn a lot about postgresql, now > I´m working i

Re: [SQL] PostgreSQL - ERROR: Cannot cast type character varying to integer

2005-07-12 Thread Mauricio Fernandez
CTED] [mailto:[EMAIL PROTECTED] Enviado el: martes, 12 de julio de 2005 13:35 Para: Mauricio Fernandez CC: pgsql-sql@postgresql.org Asunto: Re: [SQL] PostgreSQL - ERROR: Cannot cast type character varying to integer Under PostgreSQL 7.3 it was necessary to use an intermediate cast to text when co

Re: [SQL] postgresql error

2001-10-31 Thread sharmad
Sir, I m getting an error that say pg_ReadData and also after which then database connection is lost/disconnected . Can anybody tell me more about this error ? My problem is that i have a databasee with huge no. of records but if i go to take query/backup of the database the pg_Readdata error