Re: Different cast behavior of TEXT and VARCHAR
От | tomas@tuxteam.de |
---|---|
Тема | Re: Different cast behavior of TEXT and VARCHAR |
Дата | |
Msg-id | 20110412145611.GA16349@tomas обсуждение исходный текст |
Ответ на | Re: Different cast behavior of TEXT and VARCHAR (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, Apr 12, 2011 at 10:29:44AM -0400, Tom Lane wrote: > tomas@tuxteam.de 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-----
В списке pgsql-general по дате отправления: