Re: [SQL] UPDATE Multiple Records At Once?

Carlos Mennens wrote on 11.04.2012 19:50: I'm trying to update a customer record in a table however I need to change several values (cust_address, cust_contact, cust_email). My question is how do I properly format this into one single command? forza=# SELECT cust_id, cust_name, cust_address, cu

Re: [SQL] Re: Pregunta acerca de la función COPY de POSTGRES

Estas tratando de realizar esta operacion desde un stored procedure? Si es asi, investiga como se hace para concatenar variables tipo character. Creo que simplemente poner tu variable en un comando no es suficiente. Saludos, Edward Ross On 04/11/2012 10:42 AM, yeison garcia wrote: Bu

[SQL] UPDATE Multiple Records At Once?

I'm trying to update a customer record in a table however I need to change several values (cust_address, cust_contact, cust_email). My question is how do I properly format this into one single command? forza=# SELECT cust_id, cust_name, cust_address, cust_contact, cust_email forza-# FROM customer

[SQL] Re: Pregunta acerca de la función COPY de POSTGRES

> > Buenas tardes. > Mi nombre es Yeison Garcia Escobar. > > Estoy dando mis primeros pasos en postgres > y tengo la tarea de investigar las cargas masivas. > > Estuve buscando y encontre la función > COPY FROM, la cual es excelente. > > Al usar > copy _edb_scheduler.persona from 'C:/persona.t

Re: [SQL] sintax error

kevalshah writes: > At present whenever there is any error in syntax of fired query > i get error message in terms of charcter "at char 53 " > I also would like to have line no: from psql terminal.. Umm ... any reasonably recent version of psql will show syntax errors like this: regression=# se

Re: [SQL] sintax error

Hi All, I am using postgres sql. At present whenever there is any error in syntax of fired query i get error message in terms of charcter "at char 53 " I also would like to have line no: from psql terminal.. I tried making changes in scan.l Do u have any suggestive fix ? to get error as "a