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 name
>>
>
> I 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
thismail, please delete it immediately and notify the sender. Unauthorised copying, disclosure or distribution of the
materialin 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).******