| From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
|---|---|
| To: | Sergey Gigoyan <sergey(dot)gigoyan(at)gmail(dot)com> |
| Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Return table and integer value |
| Date: | 2013-02-20 05:03:55 |
| Message-ID: | CAL_0b1vn1PmTLU7Q1U8bymHMQ8c5BQPHf_TvQoDkVg8UbxTO0w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Sun, Feb 17, 2013 at 10:28 AM, Sergey Gigoyan
<sergey(dot)gigoyan(at)gmail(dot)com> wrote:
> 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 +1 415 867 9984
Russia, Moscow +7 901 903 0499
Russia, Krasnodar +7 988 888 1979
Skype: gray-hemp
Jabber: gray(dot)ru(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-02-20 08:46:44 | Re: WITH HOLD ref cursors for plpgsql |
| Previous Message | Daniel Wood | 2013-02-19 20:17:37 | Re: WITH HOLD ref cursors for plpgsql |