Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Return table and integer value

1 view
Skip to first unread message

Sergey Gigoyan

unread,
Feb 17, 2013, 1:28:48 PM2/17/13
to
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

unread,
Feb 20, 2013, 12:03:55 AM2/20/13
to
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 +1 415 867 9984
Russia, Moscow +7 901 903 0499
Russia, Krasnodar +7 988 888 1979

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


--
Sent via pgsql-novice mailing list (pgsql-...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

0 new messages