Hello everybody I need to update a field with the same value in the tables of my data base but this field exists in almost all tables and has the same value, I don't want to code a script, so my question is if there is some way to update that field with a query and affects all the tables th
Hi
how could I restore a db if I did next:
pg_dump -Z 9 soi > $DESTINO/soi.bkp
Thanks in advanced
Hello everybody!!!, I'd like to know if there another way to get the time from a timestamp type, because in earliest versions I just get the time like time(fecha) and now this returns an error, thanks in advanced!!!
Hello everybody!!!, I'd like to know if there another way to get the time from a timestamp type, because in earliest versions I just get the time like time(fecha) and now
this returns an error, thanks in advanced!!!
Hi everybody, in Postgres 7.0.2 I have the next query:
SELECT * from clientes_proceso where fecha_mod::date <= now() -1;
but in version 8.0.1 returns the next error:
ERROR: The operator doesn't exist: timestamp with time zone - integer
How can drop a day to now()??
Hello everybody I have a failure making a select in a table the error that returns is the follow:
Backend message type 0x44 arrived while idle
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processi
Excuse me, how can I send a query to a file?, for example the result of
this query:
select id_articulo, articulo, color_code from articulos;
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choos
Hello I have a query that ran in 7.0.2, but in 8.0.1 does not, the query
is the next:
select n.factura,
n.venta_neta,
c.nombre_cli || ' ' || c.apellido_pat_cli || ' ' || coalesce
(c.apellido_mat_cli,''),
date(n.fecha_hora_factura),
I moved from postgres 7.0.2 to 8.0.1,
in the 7.0.2 version I process the next query, and it succeed:
select ichar(letra_ascii) || '-' || substr('0' ||num_factura,length
(num_factura)+1,5) as factura from facturas
but in 8.0.1 it outputs the next error:
ERROR: not exist the function ichar(
