From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "daniel blanco" <daniel_b_adrian(at)hotmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: function that returns a set of records and integer(both of them) |
Date: | 2008-07-12 07:05:45 |
Message-ID: | 162867790807120005o368dcdbeh4e18eea00cff0959@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
2008/7/11 daniel blanco <daniel_b_adrian(at)hotmail(dot)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
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 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!
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2008-07-12 07:56:17 | Re: Rollback in Postgres |
Previous Message | Lewis Cunningham | 2008-07-12 01:56:28 | Re: Rollback in Postgres |