[SQL] out-subject : thanks

hi, i just "finish" a project using postgresql. i just want to thank's everyone from the mailing list who help me. in particular, bruce for your book (i wasn't a thing about database and sql 2 months ago). tom for your quick answer and eric l. http://www.mediacces.com in french... go to - media

Re: [SQL] Median

> Maybe someone else has an idea. I implemented a different algorithm several years ago. It is an O(log(N)) process (unlike most other techniques), and was borrowed from the "Algorithms" book (it's at work; but it is the classic "yellow jacket" book with Fortran code and the other volume with *re

Re: [SQL] using a self referencing table

[EMAIL PROTECTED] wrote: > i have a table with this structure > > name (varchar)|category id (int4)|parent category id (int4)|leaf node > (bool) > > im trying to make a perl script that should tree the info > > parent cat > subcat > subcat2 > subcat2 >

Re: [SQL] Median

[EMAIL PROTECTED] (Jan Wieck) writes: > I don't see any quick solution how to solve this problem with > an aggregate. Aggregates get all selected values in unsorted > order, and don't know ahead how many items there will be. > Even if, all this wouldn't be of any use, because

Re: [SQL] Database authentication and configuration

Carolyn Lu Wong writes: > Are there anywhere to configure so that whenever I call 'psql dbname', > it'll always prompt for user authentication instead of getting into the > database directly? psql from 7.0 and later should automatically ask for a password if one is required. > In addition, I'd

Re: [SQL] Median

omid omoomi wrote: > Hi, > I'll be glad if you describe more details about the problem. Is it a kind of > statistical analysis or what? > Omid Omoomi Sorry to respond that slow. It's something, Ulf Mehlig described to me a couple of months ago. The median is the value, below and

[SQL] using a self referencing table

i have a table with this structure name (varchar)|category id (int4)|parent category id (int4)|leaf node (bool) im trying to make a perl script that should tree the info parent cat subcat subcat2 subcat2 subcat subcat2 ... but

[SQL] describe table in 7.0.2

Hallo, i have table in postgres 7.0.2 migration from 6.5.3 using pg_upgrade if i \d (table name) in psql ==> "Did not find any relation named" How i describe table in postgres 7.0.2 ? Thanks Nizomi