Onfly, function generated ID for Select Query

From: Durumdara <durumdara(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Onfly, function generated ID for Select Query
Date: 2023-03-10 07:12:11
Message-ID: CAEcMXhnbLPAAAPpZZ8WoPZKOW4U3PwmSg=ztFxBZZ2FHQeJn8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gustavsson Mikael 2023-03-10 07:33:12 SV: Onfly, function generated ID for Select Query
Previous Message David G. Johnston 2023-03-09 21:24:46 Re: select (17, 42)::s.t2 into... fails with "invalid input syntax"