-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, Apr 12, 2011 at 10:29:44AM -0400, Tom Lane wrote: > tomas@xxxxxxxxxx writes: > > When PREPARing statements, the type guessing machinery seems to behave > > differently for VARCHAR and TEXT. Is this intentional? > > Your example works for me, in all branches back to 8.2: > > regression=# create table foo(a text, b varchar); > CREATE TABLE > regression=# PREPARE s1 AS SELECT a, b FROM foo WHERE a = $1; > PREPARE > regression=# PREPARE s2 AS SELECT a, b FROM foo WHERE b = $1; > PREPARE Thanks! > I wonder if you have some nondefault operators installed that are making > the query ambiguous. That would mean I managed to munge my template1. Yes, that'd be the most plausible scenario :-/ Not at my machine at the moment, will check later. Thanks and sorry for the noise. Regards - -- tomÃs -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFNpGgLBcgs9XrR2kYRAgU5AJwJnOwC0LYHAiPUC9jWASI+al95owCdGhqX EoRE7s265qjLz1yJBMERrQI= =AnaI -----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
