Re: Postgres and alias
От
Stelios Sfakianakis
Тема
Re: Postgres and alias
Дата
Msg-id
0C19E19D-F37A-488D-A1F3-370B8BB3523C@gmail.com
Ответ на
Postgres and alias (Fontana Daniel C \(Desartec S.R.L.\))
Список
Дерево обсуждения
Postgres and alias "Fontana Daniel C \(Desartec S.R.L.\)" <desartecsrl@gmail.com>
Re: Postgres and alias Stelios Sfakianakis <sgsfak@gmail.com>
Postgres and alias "Fontana Daniel C \(Desartec S.R.L.\)" <desartecsrl@gmail.com>
Re: Postgres and alias Stelios Sfakianakis <sgsfak@gmail.com>
Re: Postgres and alias Alban Hertroys <haramrae@gmail.com>
Re: Postgres and alias Paul Förster <paul.foerster@gmail.com>
Hmm, how about:
SELECT substr (ls_number, 3, 3)
FROM (VALUES('1234567890')) as t(ls_number);
St.
> On 27 Aug 2020, at 18:55, Fontana Daniel C (Desartec S.R.L.) wrote:
>
> Hi, I am migrating a database from Sybase to PostgreSql 12.
>
> This select in sybase works for me, but with postgresql it accuses me
> "THERE IS NO COLUMN ls_numero"
>
> select '1234567890' as ls_number,
> substr (ls_number, 3, 3);
>
> Is it possible to get information from an alias in postgresql? how would the
> code be?
>
>
>
>
В списке pgsql-general по дате отправления
