Comments by Priyanka Tiwari001 (Top 7 by date)

Hi Dear,

Thank u for your reference, it helped me to understand various other concepts. But in this documentation variable declaration syntax is:

user_id integer;
quantity numeric(5);

Its also raising error as:
syntax error at or near "integer"

In the documentation it has been mentioned that all variables should be declared in declaration section, then can you tell me what does it mean? Am I making any mistake in variable declaration? Please suggest me what should I do?

Thank u a lot...

Thank u for your solution but its raising error on pgadmin- postgreSQL. I think 'try' is not valid keyword in PostgreSQL because on running this query I am getting error as-

ERROR: syntax error at or near "try"
LINE 1: begin try

Could you suggest me some other solution?

Thanks a lot for your solutions and suggestions. I am working on various perspective of database as datatype and indexing. I am referring actual execution plan to get areas where improvements are required.

I mean there 3 buttons, viz. Save, Update, Delete in form and some other controls also which causes post back to server but I have to show progress bar on click of save button only. If save button is clicked progress bar should be shown but on click of any other button or any other post backs progress bar shouldn't be shown.