Re: MySQL search query is not executing in Postgres DB - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: MySQL search query is not executing in Postgres DB
Date
Msg-id c4ea734feb675718c45229eb8bb08e91@biglumber.com
Whole thread Raw
In response to Re: MySQL search query is not executing in Postgres DB  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: MySQL search query is not executing in Postgres DB
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


Tom Lane replied:
>>> Come on, really?  Note that the above example works without casts if
>>> you use int *or* bigint *or* numeric, but not smallint.  That could be
>>> fixed by causing sufficiently-small integers to lex as smallints,

>> Is there any general interest in adjusting smallint casting?
...
> It's conceivable that a change in the lexer behavior combined with a
> massive reorganization of the integer-related operators would bring us
> to a nicer place than where we are now.  But it'd be a lot of work for
> dubious reward, and it would almost certainly generate a pile of
> application compatibility problems.

Okay, but what about a more targeted solution to the original 
poster's problem? That seems doable without causing major 
breakage elsewhere....

- -- 
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201208271818
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAlA78m0ACgkQvJuQZxSWSshW2gCg1Xcx5zLORMIDQo2yE6QTLVuD
P88AniE9rh4Dojg0o416cWK7cYHWaq0b
=NOAR
-----END PGP SIGNATURE-----





pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: FATAL: bogus data in lock file "postmaster.pid": ""
Next
From: Bruce Momjian
Date:
Subject: Re: Timing overhead and Linux clock sources