Search Postgresql Archives

Re: Different cast behavior of TEXT and VARCHAR

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux