Hi Gastón, The error message you see comes from PostgreSQL - pgAdmin is just displaying it for you. I don't know what is causing it - perhaps you should try [EMAIL PROTECTED] where someone might know.
Regards, Dave. > -----Original Message----- > From: Gastón Micheri [mailto:[EMAIL PROTECTED] > Sent: 06 March 2003 21:15 > To: [EMAIL PROTECTED] > Subject: [pgadmin-hackers] Pgadmin Error > > > > > Hi, > I am working with PgAdminII and I am executing next select statement: > -------------------------------------------------------------- > --------- > select distinct > sc.concepto,sc.fec_movimiento,sc.fec_carga,sc.id_usuario_cargo, '' as > detalle_actor, 0 as > id_actor,sd.mes_ano,sd.id_subdiario,sd.id_empresa,sd.id_sucurs > al_origen,sd.nro_movimiento,sd.id_sucursal, > sd.orden,sd.debe_haber,sd.importe,pcc.SubCodigo_Contable,pcc.c > odigo_contable,pcc.detalle_codigo_contable, > sch.nro_cheque,sch.fecha_cheque,sc.id_tipo_movimiento,mt.detal > le_tipo_movimiento > from subdiarios_detalles sd join planes_cuentas_codigos pcc on > pcc.id_plan_cuenta=sd.id_plan_cuenta and pcc.SubCodigo_Contable= > sd.subcodigo_contable > left join subdiarios_cabeceras sc on sc.mes_ano = sd.mes_ano and > sc.id_subdiario =sd.id_subdiario and > sc.id_empresa = sd.id_empresa and sc.id_sucursal_origen = > sd.id_sucursal_origen and sc.nro_movimiento = > sd.nro_movimiento left join subdiarios_cheques sch on > sch.mes_ano = sd.mes_ano and > sch.id_subdiario= sd.id_subdiario and > sch.id_empresa= sd.id_empresa and sch.id_sucursal_origen= > sd.id_sucursal_origen and sch.nro_movimiento= sd.nro_movimiento and > sch.orden= sd.orden > left join movimientos_tipos mt on sc.id_tipo_movimiento = > mt.id_tipo_movimiento > > where sd.mes_ano=200302 and sd.id_subdiario='SI' and > sd.id_empresa=1 and > sd.id_sucursal_origen=7 and sd.nro_movimiento=15 > > order by sc.id_tipo_movimiento ASC, sd.debe_haber > --------------------------------------------------------------------- > > and I am getting next error: > > pgAdmin II Error > An error has occured in pgAdmin II: > frmSQLInput.cmdExecute_click: Number:-2147467259 > Description: ERROR: Unable to identify an ordering operator > '<' for type > "unknown". Use an explicit ordering operator or modify the query. > > As I do not use any '<', I have started to modify my query > and the first > thing I did was droping the 'distinct' clause from the > 'select' statement > and it worked fine, but I need that 'distinct' to be there. > Can anybody tell me why this error occurs? > Thanx, > Gastón.- > > > _________________________________________________________________ > Charla con tus amigos en línea mediante MSN Messenger: > http://messenger.yupimsn.com/ > > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an > appropriate subscribe-nomail command to > [EMAIL PROTECTED] so that your message can get through > to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
