| From: | "Sumita Biswas" <sbiswas(at)cisco(dot)com> |
|---|---|
| To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Postgres DB |
| Date: | 2004-02-23 08:54:32 |
| Message-ID: | 003a01c3f9ea$a7b58320$2a154d0a@apac.cisco.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
The following Query string , when executed does not give an Error, even
though the table Tbl_Billing_Data is not present.
QueryToPopulateTemp := ''INSERT INTO Tmp_Conference(ConferenceType,
CallManagerId, ClusterId, DestConversationId, ConnectDate,
FinalDestination)''+'' SELECT 2, Global_CallId_CallManagerId,
globalCallId_ClusterID, DestConversationID, StartDate = MIN
(Connect_Date), Final_Destination ''+'' FROM Tbl_Billing_Data'';
PERFORM QueryToPopulateTemp;
I some how feel that the Query is not getting executed at all, otherwise
its sure to give an error.
So can you please comment what would have gone wrong?
Regards,
Sumita
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jbduffy | 2004-02-23 13:21:32 | plpgsql function returning SETOF RECORD Question |
| Previous Message | john | 2004-02-23 08:44:26 | unicode(utf-8) problem ! |