On Mon, Nov 12, 2007 at 05:18:28PM -0500, Tom Lane wrote: > regression=# select '00123'::text like '0%'; > ?column? > ---------- > t > (1 row) > regression=# select '00123'::int4 like '0%'; > ?column? > ---------- > f > (1 row) i think it's definitelly ok - '00123'::text is *not equal* to '00123'::int4. so result of "like'ing" it is not necessarily the same. what's more - in case patric showed - when he had int column there was no "danger" of '00123'::int4. best regards, depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
