Sandhya, Hope this will explain, why it is so ... http://www.postgresql.org/docs/7.4/static/ddl-schemas.html Kannan Andy Shellam wrote:
In the document they mentioned that . is used as a seperator for a table/column nameI would say for this very reason the answer would be No, but I might be wrong... Andy ---------------------------(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
-- GSEC1 (A Division of ITAC UK Limited) Chennai, India | Manchester, UK Tel : +91 44 4202 2601 - 2605 Fax : +91 44 4202 2606 Mobile : +91 988411 4931 URL : www.gsec1.com ****** This email is confidential and is intended for the original recipient(s) only. If you have erroneously received this mail, please delete it immediately and notify the sender. Unauthorised copying, disclosure or distribution of the material in this mail is prohibited. Views expressed in this mail are those of the individual sender and do not bind GSec1 (A Division of ITAC UK Limited) or its subsidiary, unless the sender has done so expressly with due authority of GSec1 (A Division of ITAC UK Limited).******
begin:vcard fn:Kannan.S n:;Kannan.S org:GSEC1;R&D adr:G N Chetty Road, T. Nagar;;Level 2, 88 Anmol Palani;Chennai;Tamil Nadu;600017;India email;internet:skn@xxxxxxxxxxx title:Senior Member Technical tel;work:+91 44 4202 2601 tel;fax:+91 44 4202 2606 tel;home:+91 44 4202 2701 tel;cell:+91 988411 4931 note:*** This email is confidential and is intended for the original recipient(s) only. If you have erroneously received this mail, please delete it immediately and notify the sender. Unauthorised copying, disclosure or distribution of the material in this mail is prohibited. Views expressed in this mail are those of the individual sender and do not bind GSEC1 (A Division of ITAC UK Limited) or its subsidiary, unless the sender has done so expressly with due authority of GSEC1 (A Division of ITAC UK Limited). *** x-mozilla-html:TRUE url:http://www.gsec1.com version:2.1 end:vcard
