Using postgres 12.5 in DBA schema, this trigger is executed when the table
is updated through a logical replication. Why is it necessary to name the
schema for it to work?
When I update the table manually, if it Works.
Example.
This trigger function does not work
CREATE FUNCTION dba.ft_pos_sync_
original-
De: Stelios Sfakianakis [mailto:sgs...@gmail.com]
Enviado el: jueves, 27 de agosto de 2020 12:59
Para: Fontana Daniel C (Desartec S.R.L.)
CC: pgsql-general@lists.postgresql.org
Asunto: Re: Postgres and alias
Hmm, how about:
SELECT substr (ls_number, 3, 3)
FROM (VALUES('1234567890
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 postg
