Ok, thanks pavel............. i think i'll try set of cursors..... by the way
in t-sql i did it as follows:
table users with a field called name
create procedure list_user_by_name
@info_name varchar
as
declare @sw
begin
select @n=(select count(*) from users where name like (@info_name+'%'))
if @sw>0
begin
select * where name like (@info_name+'%')
return 1
end
else
begin
return 0
end
end
as you see i do a select and a return at the same time when de sw variable is >
than 0. i was expecting to do a similiar function with plpgsql o sql in
postgresql
> Date: Sat, 12 Jul 2008 09:05:45 +0200> From: [EMAIL PROTECTED]> To: [EMAIL
> PROTECTED]> Subject: Re: [SQL] function that returns a set of records and
> integer(both of them)> CC: pgsql-sql@postgresql.org> > 2008/7/11 daniel
> blanco <[EMAIL PROTECTED]>:> > Hi Everyone> >> > I would like to know if i
> can create a function that returns a set of record> > with the sql statement:
> select and a integer, i mean both of them, because i> > remenber that in sql
> server (transact sql) i can do that in a stored> > procedure doing a select
> statement and a return of a integer in the same> > procedure,> > when I
> worked with T-SQL this wasn't possible - stored procedure> should return
> recordset or multirecord set or OUT variables. And it> was solution. When I
> would returns some similar like you, I had to> return two recordsets.> > i'm
> migrating to postgresql and i have stored procedures like> > this in my sql
> server database, can i do that with postgresql?> > You canno
t return integer and recordset from function now. There is> one workaround,
you can return set of cursors.> > Regards> Pavel Stehule> > >> >
Thanks.........> > ________________________________> > Get news, entertainment
and everything you care about at Live.com. Check it> > out!> > -- > Sent via
pgsql-sql mailing list (pgsql-sql@postgresql.org)> To make changes to your
subscription:> http://www.postgresql.org/mailpref/pgsql-sql
_________________________________________________________________
Connect to the next generation of MSN Messenger
http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline
