Re: Postgres and alias

From: Stelios Sfakianakis <sgsfak(at)gmail(dot)com>
To: "Fontana Daniel C (Desartec S(dot)R(dot)L(dot))" <desartecsrl(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres and alias
Date: 2020-08-27 15:58:52
Message-ID: 0C19E19D-F37A-488D-A1F3-370B8BB3523C@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmail(dot)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?
>
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Förster 2020-08-27 16:03:51 Re: Postgres and alias
Previous Message Fontana Daniel C (Desartec S.R.L.) 2020-08-27 15:55:35 Postgres and alias