Dear all,
I am trying to translate a code written in php to C++. So, I am now using
lipq in order to access my postgresql database from C++.
As performance is an important feature, I am using prepared statements.
I have a SQL statement that performs a 'DELETE ... RETURNING ... ' stuff
and I
Von: pgsql-sql-ow...@postgresql.org [pgsql-sql-ow...@postgresql.org]quot; im
Auftrag von quot;Bill MacArthur [webmas...@dhs-club.com]
Gesendet: Samstag, 25. Mai 2013 09:19
An: pgsql-sql@postgresql.org
Betreff: [SQL] reduce many loosely related rows
Hi Brice,
I believe that you'll need PQcmdTuples - Returns the number of rows
affected by the SQL command.
Watch out, it returns char* instead of int. I believe it's supposed to
be used for the UPDATE ... RETURNING as well, but I'd double check on
that.
It's under 30.3.3. Retrieving
Hi Wolfe,
First, thanks for your help.
I tried your code, but it does not work... the function returns a string :
0. When I check, this command properly modifies one row, as expected.
I don't know if it may help, but just in case... The DELETE operation is
not performed on a table : it is
I have a query like this:
SELECT
lpt_titulo AS tmt_titulo,
tmd_nombre AS tmt_nombre,
tmd_album AS tmt_album
SUM(lpt_puntos) AS tmt_puntos,
lpt_fuente AS tmt_fuente
FROM listas_pre_titulos, temp_lista_titulos
WHERE
listas_pre_titulos.lpt_tipo = 3 AND
listas_pre_titulos.lpt_titulo
I have a query like this:
SELECT
lpt_titulo AS tmt_titulo,
tmd_nombre AS tmt_nombre,
tmd_album AS tmt_album
SUM(lpt_puntos) AS tmt_puntos,
lpt_fuente AS tmt_fuente
FROM listas_pre_titulos, temp_lista_titulos
WHERE
listas_pre_titulos.lpt_tipo = 3 AND
listas_pre_titulos.lpt_titulo