pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: Ian Lawrence Barwick <barwick@gmail.com>
Cc: Wen Yi <896634148@qq.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Subject: Re: How to make the generate_series to generate the letter series?
Date: Tue, 30 May 2023 21:04:48 -0400
Message-ID: <ZHadMD8uySnpxKnS@momjian.us> (raw)
In-Reply-To: <CAB8KJ=hNxXc9dz0daV_P7pxu7yz4UBJ8CMSk7_aB9Cdc8DMHjA@mail.gmail.com>
References: <tencent_A24CD2422E177547AB16A6AA906A71266E08@qq.com>
	<CAB8KJ=hNxXc9dz0daV_P7pxu7yz4UBJ8CMSk7_aB9Cdc8DMHjA@mail.gmail.com>

On Mon, May 29, 2023 at 12:51:15PM +0900, Ian Lawrence Barwick wrote:
> 2023年5月29日(月) 12:39 Wen Yi <896634148@qq.com>:
> >
> > 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!
> 
> SELECT chr(x + 96) FROM generate_series(1, 26) x

A working example is:

	SELECT chr(x + 96) FROM generate_series(1, 26) as f(x);

Here is a blog entry about more complex examples:

	https://momjian.us/main/blogs/pgblog/2012.html#July_24_2012

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.





view thread (3+ messages)

Message-ID: <ZHadMD8uySnpxKnS@momjian.us>
Permalink:  ../ZHadMD8uySnpxKnS@momjian.us/
Also on:    postgresql.org/message-id/ZHadMD8uySnpxKnS@momjian.us

 · 

reply

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: bruce@momjian.us, barwick@gmail.com, 896634148@qq.com
  Subject: Re: How to make the generate_series to generate the letter series?
  In-Reply-To: <ZHadMD8uySnpxKnS@momjian.us>
  References: <tencent_A24CD2422E177547AB16A6AA906A71266E08@qq.com> <CAB8KJ=hNxXc9dz0daV_P7pxu7yz4UBJ8CMSk7_aB9Cdc8DMHjA@mail.gmail.com> <ZHadMD8uySnpxKnS@momjian.us>

* 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