Skip to main content
Commonmark migration
Source Link

#SQL (postgreSQL), 107 101

SQL (postgreSQL), 107 101

Generate are series from -25 to 25 and use the absolute value to replace characters with their uppercase version. Thanks to manatwork for the tip about the @ operator.

select replace('abcdefghijklmnopqrstuvwxyz',chr(122- @i),chr(90- @i))from generate_series(-25,25)a(i)

#SQL (postgreSQL), 107 101

Generate are series from -25 to 25 and use the absolute value to replace characters with their uppercase version. Thanks to manatwork for the tip about the @ operator.

select replace('abcdefghijklmnopqrstuvwxyz',chr(122- @i),chr(90- @i))from generate_series(-25,25)a(i)

SQL (postgreSQL), 107 101

Generate are series from -25 to 25 and use the absolute value to replace characters with their uppercase version. Thanks to manatwork for the tip about the @ operator.

select replace('abcdefghijklmnopqrstuvwxyz',chr(122- @i),chr(90- @i))from generate_series(-25,25)a(i)
added 61 characters in body
Source Link
MickyT
  • 12.2k
  • 2
  • 26
  • 48

#SQL (postgreSQL), 107107 101

Generate are series from -25 to 25 and use the absolute value to replace characters with their uppercase version. Thanks to manatwork for the tip about the @ operator.

select replace('abcdefghijklmnopqrstuvwxyz',chr(122-abs(i) @i),chr(90-abs(i) @i))from generate_series(-25,25)a(i)

#SQL (postgreSQL), 107

Generate are series from -25 to 25 and use the absolute value to replace characters with their uppercase version.

select replace('abcdefghijklmnopqrstuvwxyz',chr(122-abs(i)),chr(90-abs(i)))from generate_series(-25,25)a(i)

#SQL (postgreSQL), 107 101

Generate are series from -25 to 25 and use the absolute value to replace characters with their uppercase version. Thanks to manatwork for the tip about the @ operator.

select replace('abcdefghijklmnopqrstuvwxyz',chr(122- @i),chr(90- @i))from generate_series(-25,25)a(i)
Source Link
MickyT
  • 12.2k
  • 2
  • 26
  • 48

#SQL (postgreSQL), 107

Generate are series from -25 to 25 and use the absolute value to replace characters with their uppercase version.

select replace('abcdefghijklmnopqrstuvwxyz',chr(122-abs(i)),chr(90-abs(i)))from generate_series(-25,25)a(i)