Re: [SQL] apt.postgresql.org vs. Pitti PPA - install error

2013-09-11 Thread Jan Lentfer
Am 11.09.2013 11:51, schrieb rawi: > Same conditions: > > Ubuntu 13.04 64bit (raring) > > /etc/apt/sources.list.d/apt_postgresql_org.list contains: > > deb http://apt.postgresql.org/pub/repos/apt/ [1] precise-pgdg main > > lsb_release -c > Codename: raring > > Same fault: > > The follow

Re: [SQL] Job control in sql

2012-05-25 Thread Jan Lentfer
On Fri, 25 May 2012 10:28:03 +0200, Svenne Krap wrote: [...] The problem is that a later run of run_jobs() will not see the job_begun has been set by a prior run (that is unfinished - as all queries from the plpgsql-function runs in a single, huge transaction). My intitial idea was to set t

Re: [SQL] Select row cells as new columns

2012-05-25 Thread Jan Lentfer
On Fri, 25 May 2012 02:03:41 -0700 (PDT), danycxxx wrote: [...] The question: How can I achive this output? nume, prenume, cnp, nume anterior, stare civila, ... (as columns - built from unique rows from infos) a , a, ... b , b, ... (as rows) Did you look at crosstab functio