Re: [GENERAL] Reg: BULK COLLECT

-structures.html#PLPGSQL-RECORDS-ITERATING Thank You Adrian. Thanks & Regards Medhavi Mahansaria Tata Consultancy Services Limited Unit-VI, No.78, 79& 83, L-Centre, EPIP Industrial Estate, Whitefield Bangalore - 560066,Karnataka India Ph:- +91 80 67253769 Cell:- +91 9620053040 Mailto: medhavi

[GENERAL] Reg: BULK COLLECT

How can i change the 'BULK COLLECT' fetch of the data from the cursor to make if compatible for pg/plsql? Thanks & Regards Medhavi Mahansaria Mailto: medhavi.mahansa...@tcs.com =-=-= Notice: The information contained in this e-mail message and/or attachments

Re: [GENERAL] Reg: PL/pgSQL commit and rollback

Yes. I have read this document. But my issue is that even when it throws and exception I need to rollback the changes made by that query and move on to the next block. Is there any way to accomplish that? Thanks & Regards Medhavi Mahansaria Tata Consultancy Services Limited Unit-VI, No.78

[GENERAL] Reg: PL/pgSQL commit and rollback

and all follow the same concept) END; / How can i acheive the same output/flow in PL/pgSQL? Can you please share a converted code snippet for my reference. Thanks & Regards Medhavi Mahansaria Cell:- +91 9620053040 =-=-= Notice: The information contained in this e-mail

Re: [GENERAL] #PERSONAL# Reg: date going as 01/01/0001

Dear Kevin, Thanks! it worked :) Medhavi Mahansaria Tata Consultancy Services Limited Unit-VI, No.78, 79& 83, L-Centre, EPIP Industrial Estate, Whitefield Bangalore - 560066,Karnataka India Ph:- +91 80 67253769 Cell:- +91 9620053040 Mailto: medhavi.mahansa...@tcs.com Website:

Re: [GENERAL] #PERSONAL# Reg: date going as 01/01/0001

LL values? Thanks & Regards Medhavi Mahansaria Tata Consultancy Services Limited Unit-VI, No.78, 79& 83, L-Centre, EPIP Industrial Estate, Whitefield Bangalore - 560066,Karnataka India Ph:- +91 80 67253769 Cell:- +91 9620053040 Mailto: medhavi.mahansa...@tcs.com

Re: [GENERAL] #PERSONAL# Reg: date going as 01/01/0001

lect * from check_date; some_date | sno |new_date ---+-+ 01/01/0001 BC | 1 | 01/01/0001 00:00:00 BC (1 row) I need to enter NULL as my date. but since I am getting these variables into the bind variables as empty string that is this issue is happening. Thanks & Re

[GENERAL] #PERSONAL# Reg: date going as 01/01/0001

Hi, I need to enter the date in null column based on the results obtained. but my date gets inserted as 01/01/0001 in postgresql 9.3 when there is no value. I need to enter NULL in the column. can anyone please help me out. Its urgent. Thanks in advance. Regards Medhavi Mahansaria Tata

Re: [GENERAL] #Personal#: Reg: Multiple queries in a transaction

follows the same concept across multiple queries. How can I incorporate this? Thanks & Regards Medhavi Mahansaria Tata Consultancy Services Limited Unit-VI, No.78, 79& 83, L-Centre, EPIP Industrial Estate, Whitefield Bangalore - 560066,Karnataka India Ph:- +91 80 67253769 Cell:- +91 96

Re: [GENERAL] #Personal#: Reg: Multiple queries in a transaction

the same concept across multiple queries. How can I incorporate this? Thanks & Regards Medhavi Mahansaria Tata Consultancy Services Limited Unit-VI, No.78, 79& 83, L-Centre, EPIP Industrial Estate, Whitefield Bangalore - 560066,Karnataka India Ph:- +91 80 67253769 Cell:- +91 962005304

[GENERAL] #Personal#: Reg: Multiple queries in a transaction

ot; I want to move ahead in the transaction and execute Q3 also even though Q2 was a failure. Can you please suggest a way to do so in PostgreSQL 9.3. Is there a way to turn autocommit off? Thanks & Regards Medhavi Mahansaria Tata Consultancy Services Limited Unit-VI, No.78, 79& 83