RE: [SQL] function that returns a set of records and integer(both of them)‏

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: pavel.stehule@gmail.com
> To: daniel_b_adrian@hotmail.com
> 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 <daniel_b_adrian@hotmail.com>:
> > 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
> re turn 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 cannot 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  Get it now!