[SQL] Need Postgresql Help

[Atul]

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 from perl
script with parameters. ? 
    3)How to return resultset from
that Stored Procedure ? 

I hope your kind co-operation. 
Thank You, 

Regards, 

Atul…

[SQL] Stored Procedure Problem

[Atul]

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;

  
return an_integer;

END;

'

LANGUAGE 'plpgsql';

 

I create the procedure . After that I run the statement like

 

Test=#> select b_function();

 

Error comes like

 

Error:
ERROR:  SELECT query has no
destination for result data.

    If
you want to discard the results, use PERFORM instead.

WARNING:  Error occurred while executing PL/pgSQL
function b_function

WARNING:  line 4 at SQL statement

 

Also I use PERFORM statement. But still problem is not resolved.

 

Please Help me. I hope your kind co-operation.

 

Thanks.

 

Atul…

Re: [SQL] Stored Procedure Problem

[Atul]

Hi,

  How
to return multiple columns through stored procedure.

 

Consider
EX.

 

CREATE FUNCTION
b_function() RETURNS varchar AS '

 DECLARE

    an_integer int4;

    an_name    varchar;

 BEGIN

    select into an_integer
emp_id,an_name emp_name from employee;

    return 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

[Atul Pedgaonkar]

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 from perl script with paratmeters. ?
3)How to return resultset from that Stored Procedure ?

I hope your kind co-operation.
Thank You,

Regards,

Atul…










_
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[SQL] Postgresql To Oracle9i

[Atul Pedgaonkar]

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 extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

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

[Atul Pedgaonkar]

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)

   But this gives error.

   ERROR:  parser: parse error at or near "varchar"

 Please anyone give me the solution for the above.


Thank you.

Regards,
Atul


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] About Postgresql Service on SUN OS

[Atul Pedgaonkar]

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

[Atul Pedgaonkar]

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.

[Atul Kumar]

Hi,
I am using PostgreSql  8.4 for my web application also  am 
using following technology stacks:

1> Java

2> Window XP (OS).

3> JBoss Server4.2.
My issue is, first time I am creating the table and inserting some rows of 
data. After doing some logic going 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 Ltd. It is intended only for the use of the 
individual or entity to which it is addressed. If you are not the intended 
recipient, you are not authorized to read, retain, copy, print, distribute or 
use this message. If you have received this communication in error, please 
notify the sender and delete all copies of this message. Persistent Systems 
Ltd. does not accept any liability for virus infected mails.