Postgres and alias

From: "Fontana Daniel C \(Desartec S(dot)R(dot)L(dot)\)" <desartecsrl(at)gmail(dot)com>
To: <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Postgres and alias
Date: 2020-08-27 15:55:35
Message-ID: 001301d67c8a$814d82c0$83e88840$@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stelios Sfakianakis 2020-08-27 15:58:52 Re: Postgres and alias
Previous Message Daniel Jakots 2020-08-27 15:28:46 could not send data to client: Permission denied