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
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
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,
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
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.
--
__
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.
--
_