Re: MySQL search query is not executing in Postgres DB
From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Robert Haas <robertmhaas(at)gmail(dot)com>
Cc:
Bruce Momjian <bruce(at)momjian(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>,
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>,
premanand <kottiprem(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: MySQL search query is not executing in Postgres DB
Date:
2012-08-27 23:13:55
Message-ID:
11931.1346109235@sss.pgh.pa.us (view raw or flat )
Thread:
2012-02-17 05:33:37 from premanand <kottiprem(at)gmail(dot)com>
2012-02-17 07:45:46 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-02-17 09:22:32 from premanand <kottiprem(at)gmail(dot)com>
2012-02-17 12:53:39 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-02-17 15:16:23 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-17 15:27:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-02-17 16:58:10 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-17 17:14:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-02-17 17:59:40 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-17 18:21:27 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-02-17 19:28:21 from Christopher Browne <cbbrowne(at)gmail(dot)com>
2012-02-17 19:39:17 from Don Baccus <dhogaza(at)pacifier(dot)com>
2012-02-17 19:44:03 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-02-17 20:04:59 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-18 00:12:37 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-02-18 00:19:48 from Don Baccus <dhogaza(at)pacifier(dot)com>
2012-02-18 20:57:15 from Rob Wultsch <wultsch(at)gmail(dot)com>
2012-02-18 21:12:04 from Don Baccus <dhogaza(at)pacifier(dot)com>
2012-02-18 21:43:12 from Christopher Browne <cbbrowne(at)gmail(dot)com>
2012-02-18 22:34:24 from Don Baccus <dhogaza(at)pacifier(dot)com>
2012-02-18 22:55:43 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-02-18 23:03:06 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-02-19 01:14:19 from Christopher Browne <cbbrowne(at)gmail(dot)com>
2012-02-19 04:10:01 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-19 04:10:38 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-17 19:52:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-17 20:05:43 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-02-18 16:51:22 from "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
2012-08-27 19:13:45 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-08-27 20:03:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-27 20:21:13 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-08-27 21:03:57 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-08-27 23:13:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-28 14:04:29 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-08-28 16:47:40 from Greg Stark <stark(at)mit(dot)edu>
2012-08-28 17:06:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-28 17:32:51 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-08-28 17:39:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-28 18:36:35 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-08-28 18:55:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-28 20:33:33 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-08-28 20:47:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-29 02:58:02 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-08-29 03:23:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-29 04:27:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-29 11:34:35 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-08-29 11:40:09 from Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
2012-08-29 15:40:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-29 18:14:56 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2012-08-29 19:54:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-29 21:08:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-08-29 22:39:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-30 13:06:39 from David Fetter <david(at)fetter(dot)org>
2012-08-30 13:13:08 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-06 15:57:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-19 23:19:06 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2012-11-21 14:42:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-21 22:10:01 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2012-11-22 15:17:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-25 23:36:57 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-25 23:46:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-26 00:21:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-27 22:05:58 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2012-11-26 02:08:24 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-27 21:36:44 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2012-12-10 19:07:53 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-12-10 20:53:42 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2012-12-11 05:59:44 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-12-11 06:22:10 from Darren Duncan <darren(at)darrenduncan(dot)net>
2012-12-14 18:51:56 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-12-14 19:11:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-14 20:20:08 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-12-16 13:21:27 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2012-11-25 23:31:46 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-25 23:42:45 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-11-26 00:05:27 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-11-26 00:24:26 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-26 00:36:31 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-11-26 01:16:13 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-26 00:39:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-26 02:08:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-27 09:46:58 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-11-27 17:19:43 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-27 17:47:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-27 18:50:55 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-27 19:26:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-27 20:35:10 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-27 20:48:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-27 20:29:43 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-11-27 18:45:21 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-11-27 19:13:43 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-27 19:59:18 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-11-27 20:41:03 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-27 22:24:16 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-12-14 07:35:29 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-11-27 20:21:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-27 21:02:27 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-12-09 17:16:17 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2012-12-14 07:30:42 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-11-21 15:27:25 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-11-21 16:01:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-27 09:59:04 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-11-27 10:10:40 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2012-11-27 16:40:37 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-27 16:52:48 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2012-11-27 17:07:54 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2012-11-27 22:09:15 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2012-11-27 22:24:05 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2012-11-27 22:41:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-27 23:25:39 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2012-11-28 05:51:01 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2012-11-27 23:36:57 from John R Pierce <pierce(at)hogranch(dot)com>
2012-12-16 14:40:44 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2012-08-29 10:01:14 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-08-29 06:59:10 from Benedikt Grundmann <bgrundmann(at)janestreet(dot)com>
2012-08-29 01:46:00 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
2012-08-27 22:19:43 from "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
2012-08-28 17:40:28 from Jim Nasby <jim(at)nasby(dot)net>
2012-02-17 20:02:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-02-17 17:27:03 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2012-02-17 17:29:36 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2012-02-17 18:31:53 from Jeff MacDonald <jam(at)zoidtechnologies(dot)com>
Lists:
pgsql-hackers
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> I agree that redefining the lexer behavior is a can of worms. What I
> don't understand is why f(2+2) can't call f(smallint) when that's the
> only extant f. It seems to me that we could do that without breaking
> anything that works today: if you look for candidates and don't find
> any, try again, allowing assignment casts the second time.
Yeah, possibly. Where would you fit that in the existing sequence of
tests?
http://www.postgresql.org/docs/devel/static/typeconv-func.html
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2012-08-27 23:35:14Subject : Re: FATAL: bogus data in lock file "postmaster.pid": ""Previous :From : Bruce MomjianDate : 2012-08-27 22:43:56Subject : Re: Incorrect behaviour when using a GiST index on points
