How to make the generate_series to generate the letter series?

From: Wen Yi <896634148(at)qq(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: How to make the generate_series to generate the letter series?
Date: 2023-05-29 03:39:34
Message-ID: tencent_A24CD2422E177547AB16A6AA906A71266E08@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi team,
when I study the generate_series function, I found that it can not only generate the number series but also can generate the date series.(ref: https://www.postgresql.org/docs/current/functions-srf.html)
That means I can make the generate_series to generate the letter series.

So I try this command (I guess I can follow the ascil code rule to complete this work):

# SELECT * FROM generate_series('a'::int, 'z'::int, 1);

But the postgres reply me a error, because the 'a' can't translate into 'integer' type.

Can someone provide me a better solution?
Thanks in advance!

Yours,
Wen Yi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Lawrence Barwick 2023-05-29 03:51:15 Re: How to make the generate_series to generate the letter series?
Previous Message Wen Yi 2023-05-29 01:32:46 Re: A question about generate_series