hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > On Mon, Nov 12, 2007 at 11:26:09AM -0500, Tom Lane wrote: >> hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: >>> on the other hand. while i know and understand why there can't be "=" >>> operator for text and int, i think that "like" could be readded as it is >>> really clear about how it works. >> Really?
> yes. i still hold my opinion: *int* like *text* is clear. regression=# select '00123'::text like '0%'; ?column? ---------- t (1 row) regression=# select '00123'::int4 like '0%'; ?column? ---------- f (1 row) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/