Re: prepared statements

	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