SV: Onfly, function generated ID for Select Query
| От | Gustavsson Mikael |
|---|---|
| Тема | SV: Onfly, function generated ID for Select Query |
| Дата | |
| Msg-id | 7e3ca307301b4928a23c3c0a8cc2b576@smhi.se обсуждение исходный текст |
| Ответ на | Onfly, function generated ID for Select Query (Durumdara <durumdara@gmail.com>) |
| Ответы |
Re: Onfly, function generated ID for Select Query
|
| Список | pgsql-general |
Hi,
Is it something like row_number() you want?https://www.postgresql.org/docs/current/functions-window.html
KR
Mikael
Från: Durumdara <durumdara@gmail.com>
Skickat: den 10 mars 2023 8:12
Till: Postgres General
Ämne: Onfly, function generated ID for Select Query
Skickat: den 10 mars 2023 8:12
Till: Postgres General
Ämne: Onfly, function generated ID for Select Query
Dear Members!
I'm searching for a simple solution, like this:
select GetIDForThisSelect(1, 1) as UID, * from anytablehasdoublestringkey
join othertablehasnotuniqueintegerkey ...
where ....
Ok, I can make a sequence, but I don't want to use persistent data.
It is enough to get 1...N as UID for this select.
Like generate_series, but that is generating rows.
Maybe you have some trick to do this.
Thank you for any assistance!
Best regards
dd
В списке pgsql-general по дате отправления: