How to create data serie in Postgresql without function generate_series

Question

I need to create data series with the value from 0 to 100 with a step of 0.1 Unfortunately, function generate_series() does not work with my database. does anyone know any other way to create a series like this? Thank you in advance.

Every Postgres version supports generate_series() - are you sure you are using Postgres? What does select version(); give you? — user330315
– user330315, Commented Sep 17, 2019 at 21:21
You are not using Postgres if you don't have generate_series(). Please correctly identify the database you are using. — Gordon Linoff
– Gordon Linoff, Commented Sep 18, 2019 at 1:38
Thank you very much. You are right. This is not PostgreSQL. This is Vertica Analitica database — Ljubiša Borojević
– Ljubiša Borojević, Commented Sep 18, 2019 at 6:04

Lukasz Szozda · Accepted Answer · 2019-09-17 19:49:30Z

2

One way is to use recursive cte:

WITH RECURSIVE CTE(c) AS (
  VALUES (0.0)
  UNION ALL
  SELECT c + 0.1
  FROM cte
  WHERE c <= 100
)
SELECT *
FROM CTE;

db<>fiddle demo

answered Sep 17, 2019 at 19:49

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create data serie in Postgresql without function generate_series

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related