Postgres Pro
Downloads
Home   >   mailing lists

Postgres and alias - Mailing list pgsql-general

From Fontana Daniel C \(Desartec S.R.L.\)
Subject Postgres and alias
Date
Msg-id 001301d67c8a$814d82c0$83e88840$@gmail.com
Whole thread Raw
Responses Re: Postgres and alias  (Stelios Sfakianakis <sgsfak@gmail.com>)
Re: Postgres and alias  (Paul Förster <paul.foerster@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Daniel Jakots
Date:
Subject: could not send data to client: Permission denied
Next
From: Stelios Sfakianakis
Date:
Subject: Re: Postgres and alias