I am trying to replicate the following code in SQL Server to PostgreSQL:
declare @row int = 1
while (@row < 6)
begin
print replicate('* ', @row)
set @row = @row + 1
end;
Required output
*
* *
* * *
* * * *
* * * * *
Add a comment
|
2 Answers
You can use generate_series()
select rpad('*', i, '*')
from generate_series(1,5) as g(i)
3 Comments
BhishanPoudel
I just tested in pgAdmin and it works. Thanks a lot.
BhishanPoudel
A small follow up question, how to print in reverse? i.e. 5stras, 4stars, etc.
@MilkyWay001: switch the order of
generate_series()dbfiddle.uk/…Loops should be avoided when possible. In SQL Server, you can use an ad-hoc tally table
Example
Select Top (5) Stars=replicate('*',Row_Number() Over (Order By (Select NULL)))
From master..spt_values n1
Returns
Stars
*
**
***
****
*****
EDIT - Descending Order
Select Stars = replicate('*',N)
From (Select top (5) N=Row_Number() Over (Order By (Select NULL)) From master..spt_values n1 ) A
Order By N Desc
7 Comments
John Cappelletti
@MilkyWay001 It really does work in SQL Server. I was really demonstrating that loops should be avoided. The SQL Server option would be as above See dbfiddle.uk/…
BhishanPoudel
Thanks John, it works in sql-server but I was trying to replicate this in postgresql.
BhishanPoudel
How to print in reverse order like 5 stars, 4stars, etc in ms-server (I guess you prefer ms-server)?
John Cappelletti
@MilkyWay001 Take a peek at stackoverflow.com/questions/61125707/…
BhishanPoudel
Thanks a lot. That's a lot of advanced than I expected. I need to brush up more of my SQL skills.
|