Harpreet Dhaliwal wrote: > Hi, > Just wanted to know how would it make a difference if i use text datatype > instead of varchar.
See FAQ item. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match