Re: [GENERAL] Different cast behavior of TEXT and VARCHAR

2011-04-12 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, Apr 12, 2011 at 10:29:44AM -0400, Tom Lane wrote: > to...@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, i

Re: [GENERAL] Different cast behavior of TEXT and VARCHAR

2011-04-12 Thread Tom Lane
to...@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

[GENERAL] Different cast behavior of TEXT and VARCHAR

2011-04-11 Thread tomas
-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 hel