Re: Schema variables - new implementation for Postgres 15

Поиск
Список
Период
Сортировка
Искать
От
Dmitry Dolgov
Тема
Re: Schema variables - new implementation for Postgres 15
Дата
Msg-id
20240128200905.43isueieauhmkyjs@erthalion.local
Ответ на
Список
Дерево обсуждения
Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 "Joel Jacobson" <joel@compiler.org>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
RE: Schema variables - new implementation for Postgres 15 "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Gilles Darold <gilles@darold.net>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Gilles Darold <gilles@darold.net>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Erik Rijkers <er@xs4all.nl>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Gilles Darold <gilles@darold.net>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Jaime Casanova <jcasanov@systemguards.com.ec>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Jaime Casanova <jcasanov@systemguards.com.ec>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Schema variables - new implementation for Postgres 15 Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Schema variables - new implementation for Postgres 15 Dean Rasheed <dean.a.rasheed@gmail.com>
Re: Schema variables - new implementation for Postgres 15 "Joel Jacobson" <joel@compiler.org>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 "Joel Jacobson" <joel@compiler.org>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Dean Rasheed <dean.a.rasheed@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15+1 Justin Pryzby <pryzby@telsasoft.com>
Re: Schema variables - new implementation for Postgres 15+1 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15+1 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Justin Pryzby <pryzby@telsasoft.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Justin Pryzby <pryzby@telsasoft.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Erik Rijkers <er@xs4all.nl>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Erik Rijkers <er@xs4all.nl>
Re: Schema variables - new implementation for Postgres 15 Erik Rijkers <er@xs4all.nl>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Erik Rijkers <er@xs4all.nl>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Erik Rijkers <er@xs4all.nl>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Erik Rijkers <er@xs4all.nl>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Justin Pryzby <pryzby@telsasoft.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Erik Rijkers <er@xs4all.nl>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Erik Rijkers <er@xs4all.nl>
Re: Schema variables - new implementation for Postgres 15 Justin Pryzby <pryzby@telsasoft.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Marcos Pegoraro <marcos@f10.com.br>
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Justin Pryzby <pryzby@telsasoft.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Schema variables - new implementation for Postgres 15 Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Erik Rijkers <er@xs4all.nl>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
RE: Schema variables - new implementation for Postgres 15 "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule <pavel.stehule@gmail.com>
> On Sun, Jan 28, 2024 at 08:34:40PM +0100, Pavel Stehule wrote:
> > * I've noticed an interesting result when a LET statement is used to
> > assign a
> >   value without a subquery:
> >
> >         create variable test as text;
> >         -- returns NULL
> >         select test;
> >
> >         -- use repeat directly without a subquery
> >         let test = repeat("test", 100000);
> >
> >         -- returns NULL
> >         select test;
> >
> >   I was expecting to see an error here, is this a correct behaviour?
> >
>
> what is strange on this result?

Never mind, I've got confused about the quotes here -- it was referring
to the variable content, not a string.


В списке pgsql-hackers по дате отправления
От: Pavel Luzanov
Дата:
От: Pavel Luzanov
Дата:
FAQ