SV: Onfly, function generated ID for Select Query

[Gustavsson Mikael <mikael.gustavsson@xxxxxxx>]

Hi,

Is it something like row_number() you want?

https://www.postgresql.org/docs/current/functions-window.html

KR

Mikael

---

Från: Durumdara <durumdara@xxxxxxxxx>
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