Re: Postgres and alias

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.) <desartecsrl@gmail.com> 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?
>
>
>
>