Hi Daniel, > On 27. Aug, 2020, at 17:55, Fontana Daniel C (Desartec S.R.L.) > <desartec...@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?
try this: postgres=# select ls_number, substr (ls_number, 3, 3) from (select '1234567890' as ls_number) a; ls_number | substr ------------+-------- 1234567890 | 345 (1 row) Cheers, Paul
