Re: [GENERAL] Postgres with php3

2000-06-21 Thread Andrew McMillan
Andrew. -- _____ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

Re: [GENERAL] Can't put sub-queries values in queries results?

2000-07-21 Thread Andrew McMillan
NT(*) FROM t2 WHERE t2.f2=$1; ' LANGUAGE 'SQL'; Then you should be able to: SELECT f1, count_subs(f1) FROM t1; Hope that helps, Andrew. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

Re: [GENERAL] Can't put sub-queries values in queries results?

2000-07-22 Thread Andrew McMillan
D or GPL in ways that I wouldn't dream of tying myself to a commercial product. Also, most of my experience with databases is with non-SQL ones, where extensions are just the whole 4GL / query language :-) Are functions not available in other SQL dialects? Cheers,

Re: [GENERAL] php update problems

2000-08-22 Thread Andrew McMillan
x27; topic='$topic2' body='$body2' person='$person2' > id2='$id';" ); UPDATE news SET date='$date', topic='$topic', body='$body', person='$person' WHERE date='$date2' AND topic='$topic2' AND bod

Re: [GENERAL] DateStyle causes drama during upgrade

2000-08-22 Thread Andrew McMillan
onventions to US conventions. I suspect this is Debian specific. Perhaps there should be a way of setting the conventions side of things in the /etc/postgresql/postmaster.init like there is a way of setting the format? Regards, Andrew. -- __

[GENERAL] Re: [NOVICE] Re: psql with PHP question

2001-05-07 Thread Andrew McMillan
FROM article ORDER BY id DESC LIMIT 1; Since that will use an index on article.id if article is a big table, has been vacuum analyzed, and has an index available. Regards, Andrew. -- _