Re: Getting a primitive numeric value from "DatumGetNumeric"?

2018-02-20 Thread Tom Lane
Demitri Muna writes: > I’m writing a C extension for PostgreSQL. One possible input datatype for my > function is a numeric array, e.g. ARRAY[[1.5,2.5],[3.5,4.5]]. I can use > “DatumGetNumeric” to extract a “Numeric” data type from the data, but at some > point I need

Getting a primitive numeric value from "DatumGetNumeric"?

2018-02-20 Thread Demitri Muna
Hi, I’m writing a C extension for PostgreSQL. One possible input datatype for my function is a numeric array, e.g. ARRAY[[1.5,2.5],[3.5,4.5]]. I can use “DatumGetNumeric” to extract a “Numeric” data type from the data, but at some point I need to convert this to a number (e.g. double) so that

Re: Crear Una FUNTION usando ROW_NUMBER

2018-02-20 Thread yeli
Buen dia, ya corregui la primera parte, me fije después que envié el correo y lo Los datos en la tabla vargas, no necesariamente son solo de vargas, tenia la intención de hacer que, como estos datos son datos de producción la intención era que todo los datos que pertenecieran a la mismo Huso

Re: query performance

2018-02-20 Thread PT
On Sun, 18 Feb 2018 00:35:18 +0100 hmidi slim wrote: > Hi, > I have two tables: establishment which contains these columns: id, name, > longitude, latitude, geom (Geometric column) > Product contains: id, name, establishment_id > First of all I want to select the

Re: Crear Una FUNTION usando ROW_NUMBER

2018-02-20 Thread Hellmuth Vargas
Hola Yeli Respondo entre lineas El 20 de febrero de 2018, 12:26, yeli escribió: > Buen día, estoy intento crear un código concatenada a través de una > función que haga lo siguiente: > > Tengo una base de datos postgresql que esta asociada a un software GIS. > > Basicamente

Re: Performance issues during backup

2018-02-20 Thread Stephen Frost
Greetings, * Dylan Luong (dylan.lu...@unisa.edu.au) wrote: > We perform nighty base backup of our production PostgreSQL instance. We have > a script that basically puts the instance into back mode and then backs up > (tar) the /Data directory and then takes it out of backup mode. > Ie, > psql

Crear Una FUNTION usando ROW_NUMBER

2018-02-20 Thread yeli
Buen día, estoy intento crear un código concatenada a través de una función que haga lo siguiente: Tengo una base de datos postgresql que esta asociada a un software GIS. Basicamente es una tabla donde se guardan datos sobre centros poblados, estos centros poblados tienen datos que al

Re: stored procedure call is not working with "select procedure()" option

2018-02-20 Thread Alban Hertroys
> On 20 Feb 2018, at 8:13, Abhra Kar wrote: > > Hi , > I have a stored procedure name "procedure()". Which I am calling by > -- > > Session sess = (Session)entityManager.getDelegate(); //entityManager is > javax.persistent.EntityManager[ Properly Initialise] >

Re: stored procedure call is not working with "select procedure()" option

2018-02-20 Thread Abhra Kar
On Tue, Feb 20, 2018 at 9:52 PM, Adrian Klaver wrote: > On 02/20/2018 08:17 AM, Abhra Kar wrote: > >> >> >> On Tue, Feb 20, 2018 at 9:21 PM, Adrian Klaver > > wrote: >> > > >> >> Please provide me the list

Re: stored procedure call is not working with "select procedure()" option

2018-02-20 Thread Adrian Klaver
On 02/20/2018 08:17 AM, Abhra Kar wrote: On Tue, Feb 20, 2018 at 9:21 PM, Adrian Klaver > wrote: Please provide me the list email.I don't know about it. The list email is the one you used already:

Re: stored procedure call is not working with "select procedure()" option

2018-02-20 Thread Adrian Klaver
On 02/20/2018 07:35 AM, Abhra Kar wrote: Please also reply to list so more people can see and answer. Ccing list On Tue, Feb 20, 2018 at 8:46 PM, Adrian Klaver > wrote: On 02/19/2018 11:13 PM, Abhra Kar wrote: Hi ,

Re: stored procedure call is not working with "select procedure()" option

2018-02-20 Thread Adrian Klaver
On 02/19/2018 11:13 PM, Abhra Kar wrote: Hi ,          I have a stored procedure name "procedure()". Which I am calling by -- Session sess = (Session)entityManager.getDelegate(); //entityManager is javax.persistent.EntityManager[ Properly Initialise]              

Re: Performance issues during backup

2018-02-20 Thread Rene Romero Benavides
What about sending the backup to a different server? through ssh / rsync or something, that would save lots of IO activity 2018-02-20 2:02 GMT-06:00 Laurenz Albe : > Dylan Luong wrote: > > We perform nighty base backup of our production PostgreSQL instance. We > have a