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.mahansa

[GENERAL] Reg: BULK COLLECT

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 to it may contain confidential or privileged information

[GENERAL] Reg: PL/pgSQL commit and rollback

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 message and/or attachments to it may contain confidential

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, 79

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: http://www.tcs.com

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

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 Website: http://www.tcs.com

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

---+-+ 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 Regards Medhavi Mahansaria Tata Consultancy Services Limited Unit-VI, No.78

[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

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 9620053040 Mailto

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 9620053040 Mailto

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

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, L-Centre, EPIP Industrial Estate