rupesh bajaj wrote:
Hi,
Is Like operator can be used to join two relation. If yes what is its use?
And how it is used?
It tests a column for a partial match. So:
'abc' LIKE 'a%' = true
'abc' LIKE 'a_c' = true
'abc' LIKE 'A%' = false
See the manuals for details on other wildcard options and al
Hi,
Is Like operator can be used to join two relation. If yes what is its use?
And how it is used?
Thanks & Regards,
Rupesh Bajaj
"sumit kumar" <[EMAIL PROTECTED]> writes:
> Can any1 please please help me know how pgsql estimates the cardinality of
> LIKE operator ??
See patternsel() and subsidiary routines in
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c
for whichever version you are inte
Can any1 please please help me know how pgsql estimates the cardinality of LIKE operator ??ThanksSumit
