Hi,
Is it something like row_number() you want? https://www.postgresql.org/docs/current/functions-window.html KR Mikael ________________________________ Från: Durumdara <durumd...@gmail.com> 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
