Re: Postgres DB - Mailing list pgsql-sql

From Sumita Biswas
Subject Re: Postgres DB
Date
Msg-id 003a01c3f9ea$a7b58320$2a154d0a@apac.cisco.com
Whole thread Raw
In response to Re: Postgres DB  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Postgres DB  (Michael Chaney <mdchaney@michaelchaney.com>)
List 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 by date:

Previous
From: "Sumita Biswas"
Date:
Subject: EXECUTing QUERY:
Next
From: Bruce Momjian
Date:
Subject: Re: Enterprice support in PostgreSQL