Re: prepared statements
От | Daniel Verite |
---|---|
Тема | Re: prepared statements |
Дата | |
Msg-id | 25ac0333-7cf9-4410-9c43-fba7815bb918@mm обсуждение исходный текст |
Ответ на | prepared statements (Scott Frankel <frankel@circlesfx.com>) |
Ответы |
Re: prepared statements
|
Список | pgsql-general |
Scott Frankel wrote: > I've found that, for a table with a > serial sequence key as its first column, I have to specify the key in > my prepared statement or I get type errors: ERROR: column "foo_id" > is of type integer but expression is of type character varying. Let's try: test=> create table t(a serial, b int); NOTICE: CREATE TABLE will create implicit sequence "t_a_seq" for serial column "t.a" CREATE TABLE test=> prepare a as insert into t(b) values($1); PREPARE test=> execute a(2); INSERT 0 1 test=> select * from t; a | b ---+--- 1 | 2 (1 row) No error here... Best regards, -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
В списке pgsql-general по дате отправления: