[SQL] Cast in PG 8.3

2008-02-05 Thread Franklin Haut
Hi all, I´m testing the new version of PostgreSQL in windows plataform but i have a problem. In PG 8.2 Create Table temp (id int4); insert into temp values (1215); insert into temp values (1216); insert into temp values (1217); insert into temp values (1218); insert into temp values (1

Re: [SQL] Update PK Violation

2008-01-16 Thread Franklin Haut
Scott Marlowe wrote: On Jan 15, 2008 3:03 PM, Franklin Haut <[EMAIL PROTECTED]> wrote: Hi all, i have a problem with one update sentence sql. example to produce: create table temp (num integer primary key, name varchar(20)); insert into temp values (1, 'THE');

[SQL] Update PK Violation

2008-01-15 Thread Franklin Haut
Hi all, i have a problem with one update sentence sql. example to produce: create table temp (num integer primary key, name varchar(20)); insert into temp values (1, 'THE'); insert into temp values (2, 'BOOK'); insert into temp values (3, 'IS'); insert into temp values (4, 'ON'); insert into t

[SQL] SQL state: 22P02

2007-11-22 Thread Franklin Haut
") is not displayed with the SQL command on log in data/pg_log ? only appears 2007-11-22 12:55:13 BRT ERROR:  invalid input syntax for integer: "a" thanks, Franklin Haut