[SQL] Need Postgresql Help

Respected sir, Atul Pedgaonkar here from India. I am using postgresql7.2 as backend and for front-end, perl5.6.1. I need some help regarding postgresql-stored procedure. The problem is like this     1)How to create stored procedure in postgresql?     2)How can i

[SQL] Stored Procedure Problem

Hello,       Atul Here, I have one problem while accessing Database Records Or Recordset from stored procedure. Procedure is like this,   CREATE FUNCTION b_function() RETURNS int4 AS ' DECLARE    an_integer int4; BEGIN    select emp_id from employee;    r

Re: [SQL] Stored Procedure Problem

eturn an_integer,an_name;  END;  '  LANGUAGE 'plpgsql';   But This Gives Error(For Multiple column , not for single column) Please Let me know.   Thanks   Atul…

[SQL] Need Postgresql Help

Respected sir, Atul Pedgaonkar here from india. I am using postgresql7.2 as backend and for front-end ,perl5.6.1. I need some help regarding postgresql stored procedure. The problem is like this 1)How to create stored procedure in postgresql ? 2)How can i use it

[SQL] Postgresql To Oracle9i

Hello, Atul here From india.Anyone who knows how to mirgrate the data from postgresql7.2 to Oracle9i.Please give the idea or methood to transfer the data. Thank you. Regards, Atul... ---(end of broadcast)--- TIP 5: Have you checked our

Re: [SQL] How to increase Column width of table

Hello, Atul here, i have one table and i would like to increase the length of existing column and the sql statement is Exisiting Column is "vehicle_make" varchar(30) SQL: alter table commute_profile alter column "vehicle_make" varchar(100)

[SQL] About Postgresql Service on SUN OS

Hello, Any one who knows, how to start the postgresql service on sun solaris server. Please help me in this regards. Thank you. Regards, Atul Pedgaonkar ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] UNSUBSCRIBE

UNSUBSCRIBE ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[SQL] Issue while using PostgreSql 8.4.

to delete that table . I am observing application is getting hang while executing statement.execute(). Please suggest me how to fix this issue. Thanks Atul Kumar DISCLAIMER == This e-mail may contain privileged and confidential information which is the property of Persistent Systems L