Re: [GENERAL] Can't copy from file into table

> > What is "an explicit cast"? Something like this: SELECT '0.80'::float; The '::float' tell Postgresql to cast '0.80' (a string) in to a real number (float). But you can't use an explicit cast in your query. I think the problem comes o

Re: [GENERAL] Statistical Analysis

-+--+--+--- > B |0751327190 | 1|HE| > B |0718144392 | |HE| > (2 rows) > -- > thorNET - Internet Consultancy, Services & Training > Phone: 01454 854413 > Fax: 01454 854412 > http://www.thornet.co.uk Isn't it because oidrand evals as 'random() < 1/X' ? or maybe 'random() < 1/(X+1)' ? -- Guillaume Perréal - Stagiaire MIAG Cemagref (URH), Lyon, France Tél: (+33) 4.72.20.87.64

[GENERAL] Migrating from 7.0RC1 to 7.0.2 and initdb

eeded instead of returning an error and burning all the databases ? Regards. Guillaume Perréal - Stagiaire MIAG Cemagref (URH), Lyon, France Tél: (+33) 4.72.20.87.64

Re: [GENERAL] Combining two SELECTs

QL query semantics require that GROUP BY grouping occurs > before DISTINCT processing, whereas you want the other order. > > > For now, the temp table seems like a good workaround. > And splitting some complex queries in simpler ones (using temp tables) can increase performance, depending on the query. Regards, Guillaume Perréal - Stagiaire MIAG Cemagref (URH), Lyon, France Tél: (+33) 4.72.20.87.64

[GENERAL] Getting number of days in a month

OfMonth('2000-10-1') => 30 dayCountOfMonth('2001-10-1') => 30 dayCountOfMonth('2002-10-1') => 30 dayCountOfMonth('2003-10-1') => 30 dayCountOfMonth('2004-10-1') => 31 Just one question: WHY?? (Note: no trouble with February) Is there a function that give the number of days of a month? Thanks, Guillaume Perréal - Stagiaire MIAG Cemagref (URH), Lyon, France Tél: (+33) 4.72.20.87.64

[GENERAL] PostgreSQL versus Oracle

Hello, Does anybody have ever heard about PostgreSQL vs Oracle performance tests and bibliography? Thanks Guillaume Perréal Stagiaire MIAG Cemagref - URH Tél: 04.72.20.87.64  

[GENERAL] Splitting one big table into smaller ones

nguages ? Thanks, Guillaume Perréal Stagiaire MIAG Cemagref - URH France