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 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
