Hasnul Fadhly bin Hasan wrote:
Hi,
just want to share with all of you a wierd thing that i found when i
tested it.
i was doing a query that will call a function long2ip to convert bigint
to ips.
so the query looks something like this.
select id, long2ip(srcip), long2ip(dstip) from sometable
Hi Richard,
Thanks for the reply.. is that the case? i thought it would comply to
the where condition first..
and after that it will format the output to what we want..
Hasnul
Richard Huxton wrote:
Hasnul Fadhly bin Hasan wrote:
Hi,
just want to share with all of you a wierd thing that i found
On Thu, Jan 13, 2005 at 07:14:10PM +0800, Hasnul Fadhly bin Hasan wrote:
Hi Richard,
Thanks for the reply.. is that the case? i thought it would comply to
the where condition first..
and after that it will format the output to what we want..
That is in fact exactly what it's doing. The