Re: Postgres DB
От | Sumita Biswas |
---|---|
Тема | Re: Postgres DB |
Дата | |
Msg-id | 003a01c3f9ea$a7b58320$2a154d0a@apac.cisco.com обсуждение исходный текст |
Ответ на | Re: Postgres DB (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Postgres DB
|
Список | 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
В списке pgsql-sql по дате отправления: