From: Gustavsson Mikael <mikael.gustavsson@smhi.se>
To: Durumdara <durumdara@gmail.com>
Cc: Postgres General <pgsql-general@postgresql.org>
Subject: SV: Onfly, function generated ID for Select Query
Date: Fri, 10 Mar 2023 07:48:14 +0000
Message-ID: <5cc66caf91ad4c888f6ffa5cb7b4435c@smhi.se> (raw)
In-Reply-To: <CAEcMXhnWw4aewhMBkZkCJ6S=NDyjGTV=PwfzD+M0d6ZWZtoOqg@mail.gmail.com>
References: <CAEcMXhnbLPAAAPpZZ8WoPZKOW4U3PwmSg=ztFxBZZ2FHQeJn8w@mail.gmail.com>
<7e3ca307301b4928a23c3c0a8cc2b576@smhi.se>
<CAEcMXhnWw4aewhMBkZkCJ6S=NDyjGTV=PwfzD+M0d6ZWZtoOqg@mail.gmail.com>
No, the result will be ordered by the window functions order clause so no additional ordering is nessesary.
You can try this by changing it to OVER(ORDER BY product_name)
KR
Mikael
________________________________
Från: Durumdara <durumdara@gmail.com>
Skickat: den 10 mars 2023 08:41:06
Till: Gustavsson Mikael
Kopia: Postgres General
Ämne: Re: Onfly, function generated ID for Select Query
Dear Mikael!
Wooooow... that is it!
Thank you!
SELECT product_id, product_name, group_id, ROW_NUMBER () OVER (ORDER BY product_id) FROM products;
Does this mean that I have to duplicate the order by clause?
SELECT product_id, product_name, group_id, ROW_NUMBER ()
OVER (ORDER BY product_id, product_name, group_id)
FROM products
ORDER BY product_id, product_name, group_id
To get the same sequence in the ROW_ID-s, and the Query rows?
BR
dd
Gustavsson Mikael <mikael.gustavsson@smhi.se<mailto:mikael.gustavsson@smhi.se>> ezt írta (időpont: 2023. márc. 10., P, 8:33):
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<mailto:durumdara@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: mikael.gustavsson@smhi.se, durumdara@gmail.com
Subject: Re: Onfly, function generated ID for Select Query
In-Reply-To: <5cc66caf91ad4c888f6ffa5cb7b4435c@smhi.se>
References: <CAEcMXhnbLPAAAPpZZ8WoPZKOW4U3PwmSg=ztFxBZZ2FHQeJn8w@mail.gmail.com> <7e3ca307301b4928a23c3c0a8cc2b576@smhi.se> <CAEcMXhnWw4aewhMBkZkCJ6S=NDyjGTV=PwfzD+M0d6ZWZtoOqg@mail.gmail.com> <5cc66caf91ad4c888f6ffa5cb7b4435c@smhi.se>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox