Return table and integer value

[Sergey Gigoyan]

Is it possible return table (result set) and integer value from postgresql
function (For example I want return table and row counts in that table )?

[Sergey Konoplev]

On Sun, Feb 17, 2013 at 10:28 AM, Sergey Gigoyan

Post by Sergey Gigoyan
Is it possible return table (result set) and integer value from postgresql
function (For example I want return table and row counts in that table )?

It is. Use the row_number() window function. More information by the link below.

http://www.postgresql.org/docs/9.2/static/functions-window.html

--
Sergey Konoplev
Database and Software Architect
http://www.linkedin.com/in/grayhemp

Phones:
USA [phone]
Russia, Moscow [phone]
Russia, Krasnodar [phone]

Skype: gray-hemp
Jabber: ***@gmail.com