Re: [SQL] Re: [GENERAL] Link Office Word form document with data from PostgreSQL

2015-03-30 Thread avpro avpro
thank you all for your responses. I think to easiest option for me would be to use the ODBC connection. Now my problem is where to start with the VBA code; but that's for another list. cheers On 30 March 2015 at 19:51, Vincent Veyron wrote: > On Mon, 30 Mar 2015 17:37:28 +0200 > Vincenzo Campan

[GENERAL] Link Office Word form document with data from PostgreSQL

2015-03-30 Thread avpro avpro
Hi all, Have you ever experienced how to populate fields from a MS Office Word document with a PostgreSQL data available either in a table or view? I haven’t seen anything on the web; only possible with MS products, VS or Access. Thank you for your input

[GENERAL] partial text search

2015-01-08 Thread avpro avpro
> Hi, > > my task is to search partial text in the fields mentioned in query. Basically I have to tables t1 and t2 and I need to search in t1 all the codes returned by a query from t2. In t1 the values could be identical as in t2 or could be partial. For example. > > T1: > > Description > > 190201

[GENERAL] trigger Before or After

2014-11-10 Thread avpro avpro
hi, in the pgsql documentation (http://www.postgresql.org/docs/9.1/static/sql-createtrigger.html) i haven't seen anything referring to: how is affected the data inserted in the new table by a trigger Before Insert compared with a trigger After Insert? and anything related to performance for exam

[GENERAL] Fwd: function for trigger

2014-11-07 Thread avpro avpro
Hi, I have this function CREATE OR REPLACE FUNCTION sumlast_func() RETURNS trigger AS begin CASE WHEN idcar = (select idcar FROM selectedcar) THEN JOIN selectedcar ON selectedcar.idcar = actuals.idcar) update actuals set comb = comb + (select combor from combor_view where idlog = (select max(idlo