-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, When PREPARing statements, the type guessing machinery seems to behave differently for VARCHAR and TEXT. Is this intentional? This is all against PostgreSQL 8.4.5 Illustration: | tomas@floh:~$ psql foo => psql (8.4.5) => Type "help" for help. | | foo=# CREATE TABLE bar ( | foo(# a TEXT, | foo(# b VARCHAR | foo(# ); => CREATE TABLE | foo=# PREPARE s1 AS SELECT a, b FROM BAR WHERE a = $1; => PREPARE | foo=# PREPARE s1 AS SELECT a, b FROM BAR WHERE b = $1; => ERROR: could not determine data type of parameter $1 In the case of VARCHAR, I get no error if I put the placeholder in quotes (i.e. '$1'). It's no big issue for me. I'll just switch to TEXT anyway, but it's a bit surprising :-) Thanks for any insights Regards - -- tomÃs -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFNo/LUBcgs9XrR2kYRAtYVAJ4wpms/EuAhlfDmH2xKIgeFJWRS9wCfeBsY ZdlA/GaNrFS4DAyekNlH0hM= =cmap -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
