Re: [SQL] pg, mysql comparison with "group by" clause

2005-10-20 Thread Chris Travers
Greg Stark wrote: "Anthony Molinaro" <[EMAIL PROTECTED]> writes: Greg, You'll have to pardon me... I saw this comment: "I don't see why you think people stumble on this by accident. I think it's actually an extremely common need." Which, if referring to the ability to have items in th

Re: [SQL] casting character varying to integer - order by numeric

2005-10-20 Thread Bryce Nesbitt (mailing list account)
Cool, thanks. PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-20) Richard Huxton wrote: SELECT version(); ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[SQL] Problema con migracion de SQL a PostgreSQL

2005-10-20 Thread Fernando Garcia
Subject: Migracion de SQL Server 2000 a PostgreSQL hola a todos, tengo un problema hace unos dias y necesito resolverlo cuanto antes. Necesito migrar la Base de Datos de un Portal Corporativo que desarrolle en SQL a Postgresql, pero no encuentro manera de hacerlo, trate de hacerlo por el export de

[SQL] Sql - Error : Relation tmp_datos already exists

2005-10-20 Thread Adriana Marcela Aguirre
Hello! Mario Splivalo:Thank you very much for your helpl!!!   I´m working with postgres 7.4.1.  and VFoxPro 5. I call a function (Postgresql) many times from VFoxPro: sql = "select * from f_rep_datos_lab( 'USUARIO')"aaa=sqlexec(db_cone,sql, "report")   This function use temporary tables wich are cr

Re: [SQL] casting character varying to integer - order by numeric

2005-10-20 Thread Richard Huxton
Bryce Nesbitt (mailing list account) wrote: Tom Lane wrote: As a general rule, you need to be more specific than that about which version you are working with ;-) Oooh, I'd be so happy to. But I don't know. Yes, I don't know. I know which version of "psql" is installed on my local machin

Re: [SQL] casting character varying to integer - order by numeric

2005-10-20 Thread Bryce Nesbitt (mailing list account)
Tom Lane wrote: But postgres 7 rejects this with "ERROR: cannot cast type character varying to integer". As a general rule, you need to be more specific than that about which version you are working with ;-) You may find that username::text::integer will work, depending on