Re: [SQL] Postgres DB

, 2004 9:41 PM To: Sumita Biswas Cc: [EMAIL PROTECTED] Subject: Re: [SQL] Function "Sumita Biswas" <[EMAIL PROTECTED]> writes: > We installed postgres, but it did not install the default DB > "postgres". The only DB that exists in a fresh installation is "

[SQL] Input Arguments

One more query: Cant I do something like this: $2 := $2 + interval ''86399 seconds''; Where $2 is one of my input variables to the function. It gives me an error: ERROR: $2 is declared CONSTANT ---(end of broadcast)--- TIP 9: the planner will i

[SQL] Postgres DB

Hi All, Our application is using the Postgres 7.3.4-RH database that is packaged with the AS3.0 for CCM. There is a variable type called refcursor that is being used by CAR Functions in Postgres database. This variable works fine when we execute the postgres Function from the database i.e through

[SQL] CURSORS - Please help urgent.

at or near "OPEN" Please comment what can be wrong. Regards, Sumita -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 8:59 AM To: Sumita Biswas Cc: [EMAIL PROTECTED] Subject: Re: Postgres DB "Sumita Biswas" <[EMAIL PR

[SQL] Unicode Support

Hi All, This is regarding Unicode Encoding(UTF8) in Postgres. I have the following assumptions, please correct me if I am wrong: 1. Postgres Supports unicode encoding(UTF8). 2. Any database takes the default encoding unless specified. Hence we can configure a Database to support unicode(UTF8) whi

[SQL] Execute Query in Postgres Function

How do we execute a Query String in Postgresql function? Or what is the equivalent of the following Code in MSSQL Stored Procedure: SET @QueryToPopulateTemp = "INSERT INTO #Tmp_ConferenceDetail(ConferenceType, ConnectTime, DisconnectTime,DestConversationId, Duration, AppConfId, OrigDevice

[SQL] DATEADD

I had the following code in my MSSQL Stored Procedure: --Adding 23Hrs 59Mins 59Secs to the ToDate(@ld_ToDate is DateTime datatype) SET @ld_ToDate = DATEADD(ss, 86399, @ld_ToDate); I have changed it to the following for Postgres Function: --Adding 23Hrs 59Mins 59Secs to t

Re: [SQL] Postgres DB

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_Ca

[SQL] EXECUTing QUERY:

I had the following code in an MSSQL Stored Procedure: SET @QueryToPopulateTemp= "INSERT INTO #Tmp_Conference(ConferenceType, CallManagerId, ClusterId, DestConversationId, ConnectDate, FinalDestination)" +" SELECT 1, Global_CallId_CallManagerId, globalCallId_Cluster

Re: [SQL] Error Number in Function

, Sumita -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 8:59 AM To: Sumita Biswas Cc: [EMAIL PROTECTED] Subject: Re: Postgres DB "Sumita Biswas" <[EMAIL PROTECTED]> writes: > But when I type the command "psql" an

Re: [SQL] Function

We installed postgres, but it did not install the default DB "postgres". This is on 7.3.4 postgres. Any thing that we might have missed out? TIA, Sumita -Original Message- From: scott.marlowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 4:17 AM To: Sum

Re: [SQL] Function

I want to call. Any help is appreciated. Thanks, Sumita -Original Message- From: scott.marlowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 4:17 AM To: Sumita Biswas (sbiswas) Cc: 'Stephan Szabo'; [EMAIL PROTECTED] Subject: Re: [SQL] Function On Mon, 16 Fe

Re: [SQL] Function

Is this the right place to get PostgreSQL 7.3.4 from: ftp://ftp10.us.postgresql.org/pub/postgresql/source/v7.3.4/postgresql-7. 3.4.tar.gz Regards, Sumita -Original Message- From: scott.marlowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 4:17 AM To: Sumita Biswas

Re: [SQL] Function

'1/23/2004',1,1,0,5001 But I don't know how to do it in Postgresql. Any help is appreciated. Thanks, Sumita -Original Message- From: Stephan Szabo [mailto:[EMAIL PROTECTED] Sent: Monday, February 16, 2004 1:07 AM To: Sumita Biswas (sbiswas) Cc: [EMAIL PROTECTED] Subject: Re: [SQL]

FW: [SQL] Function

[mailto:[EMAIL PROTECTED] Sent: Monday, February 16, 2004 11:10 PM To: Sumita Biswas (sbiswas) Cc: [EMAIL PROTECTED] Subject: RE: [SQL] Function On Mon, 16 Feb 2004, Sumita Biswas (sbiswas) wrote: > Thanks for the answer. > I have one more issue. How do I test a function that I wrote?

[SQL] Function

Hi All, This function of mine gives a Parse Error: CREATE or replace FUNCTION Proc_ConferenceSummary(date,date,int,int,int) RETURNS SETOF tbl_error_master AS ' declare li_CallManagerId int; begin select * FROM tbl_error_master; end; ' LANGUAGE SQL; psql:Proc_ConferenceSummary.sq