Re: Postgres and alias

2020-08-28 Thread Stelios Sfakianakis
loading the base? > > something like this > > select art.description, >f_art_get_price_str( art.id ) as ls_price_and_date > SUBSTRING( ls_price_and_date, 7, 13 ) > from articulos; > > -Mensaje original- > De: Stelios Sfakianakis [mailto:sgs...@gmail.com] > Enviad

Re: Postgres and alias

2020-08-27 Thread Stelios Sfakianakis
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.) > wrote: > > Hi, I am migrating a database from Sybase to PostgreSql 12. > > This select in sybase works for me, but with postgresql

Re: Keeping state in a foreign data wrapper

2020-08-04 Thread Stelios Sfakianakis
Thank you again, I have another question in order to make sure I have a clear understanding: > On 4 Aug 2020, at 11:24, Ian Lawrence Barwick wrote: > > The hash table is specific to each running backend so will only be > accessed by that process. > > Pre-loading a shared library just gives th

Re: Keeping state in a foreign data wrapper

2020-08-03 Thread Stelios Sfakianakis
e: > > 2020年8月4日(火) 1:24 Stelios Sfakianakis : >> >> Hi, >> >> I am trying to implement a FDW in Postgres for accessing a web api and I >> would like to keep information like for example the total number of requests >> submiited. Ideally these data sho

Keeping state in a foreign data wrapper

2020-08-03 Thread Stelios Sfakianakis
Hi, I am trying to implement a FDW in Postgres for accessing a web api and I would like to keep information like for example the total number of requests submiited. Ideally these data should be kept “per-user” and of course with the proper locking to eliminate race conditions. So the question