Re: [SQL] Function Parameters - need help !!!

not as "SessionID" 3. If a value is not intiliazed it is defaulted to NULL. -- Best Regards, Vishal Kashyap Director / Lead Software Developer, Sai Hertz And Control Systems Pvt Ltd, http://saihertz.rediffblogs.com [Comming Soon http://www.saihertz.com] Yahoo IM: coeb_college[ a t

Re: [SQL] case stement when null

greSQL documentation talks very less about this i.e with out any example. I would submit a request along with example. -- Regards, Vishal Kashyap Director / Lead Software Developer, Sai Hertz And Control Systems Pvt Ltd, http://saihertz.rediffblogs.com Yahoo IM: mailforvis

Re: [SQL] PLSQL Question regarding multiple inserts

first insert made. -- Best Regards, Vishal Kashyap Director / Lead Developer, Sai Hertz And Control Systems Pvt Ltd, http://saihertz.rediffblogs.com Jabber IM: [EMAIL PROTECTED] ICQ : 264360076 Yahoo IM: [EMAIL PROTECTED] --- You yourself,

Re: [SQL] Function

the function which I want to call. If this valriable is lv_flag and you are using plpgsql just declase lv_flag as boolean and point as this lv_flag := drop_table_if_exists(''alarmconfig'',false); I hope this helps -- Best Regards, Vishal Kashyap Director / Lead

Re: [SQL] Function

Dear Sumita Biswas , We installed postgres, but it did not install the default DB "postgres". Default Db is template1 . I belive you are talking about user postgres -- Best Regards, Vishal Kashyap Director / Lead Developer, Sai Hertz And Control Systems Pvt

Re: [SQL] Trigger to identify which column(s) updated

Dear Jack , for each column in new: if (new.column(1) != old.column(1)) ... ...and then some snippet of code to determine the primary key column of new (or old) Check the following link http://gborg.postgresql.org/project/tablelog/projdisplay.php Hope this helps -- Regards, V

Re: [SQL] Trigger to identify which column(s) updated

Dear Jack , I suspect that the function would look something like; CREATE FUNCTION FIND_CHANGED_COLUMNS() RETURNS OPAQUE AS ' BEGIN -- FOR EACH COLUMN IN THE RECORD: -- IF ( NEW COLUMNx <> OLD COLUMNx) -- LOG THE RECORD PRIMARY KEY, COLUMN NAME, OLD VALUE RETURN NEW; END; ' LANGU

Re: [SQL] Copying rows between tables?

Dear Steve Wampler I have an application where old records are archived into 'archive' tables. Occasionally there is a need to copy some of these old records into the 'active' table. source_table(id: bigserial,uname: char,x1: char,x2: char,x3: char,x4: char) dest_table(id: bigserial,uname: cha

Re: [SQL] Problems with postgresql 7.4.1 configuration - URGENT

Dear Uzo , Could anyone mail me the pltcl.so file so that using createlang pltclu I can gain access to email facilities using pgmail? I am running OS X 10.3.2 I am not sure if this happens in OS X you may do something equivalent of su -c"gmake install-all-headers" add the libs path to /etc/ld.

Re: [SQL] Triggers

Dear Uzo , Hi, does postgresql support the ability to email as in SQL Server? I want to create a trigger which on input of a record will send out an email. Is this possible? http://pgmail.sourceforge.net/ is what you need. Regards, Vishal Kashyap ---(end of broadcast)

Re: [SQL] Anti log in PostgreSQL

Dear Martin Marques and other kind people out their , In mathematics I would have written it something like A = antilog (3·3234) = 2144 As I can understand, this is a 10 base log, so that what you want is 10^(3.3234)? Though antilog did not solve my problem the link below helped me to p

Re: [SQL] Anti log in PostgreSQL

Dear Wei Weng , Nope select exp(3.3234) as a2144 Gives me 27.754555808589792 But the answer expected is some what near to 2144 The log tables show this Regards, Vishal Kashyap. What is the mathematical operation that "antilog" is supposed to perform? Its going to calculate rate of intrest for an

Re: [SQL] Anti log in PostgreSQL

Dear Martin Marques , In mathematics I would have written it something like A = antilog (3·3234) = 2144 As I can understand, this is a 10 base log, so that what you want is 10^(3.3234)? For that you have the exponential operator ^. Nope select exp(3.3234) as a2144 Gives me 27.7545558085

[SQL] Anti log in PostgreSQL

Dear all , In one of our project I require to calculate antilog of (3.3234) But I could not find any functions in Documentation for the same. In mathematics I would have written it something like A = antilog (3·3234) = 2144 Any suggestions or links are most welcome . Regards, Vishal Kashyap.