mer's
(bad) code :-)
Cheers,
--
Jean-Paul Argudo
www.PostgreSQLFr.org
www.dalibo.com
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
ng the
function, so:
select get_table_count('bar') as bar;
bar
-
3
(1 row)
I don't know any other way to do that...
Cheers,
--
Jean-Paul Argudo
www.PostgreSQLFr.org
www.dalibo.com
---(end of broadcast)---
TIP 9: In versio
e 'SELECT count(*) FROM '||tablename into rowcount;
return rowcount;
END;
$$ LANGUAGE 'plpgsql';
select get_table_count('bar');
get_table_count
-----
3
(1 row)
Cheers,
--
Jean-Paul Argudo
www.PostgreSQLFr.org
www.dalibo.com
onvinced this method is the best so far. I used it in 3
different projects where I had to implement big trees structures on a
table. They all still work with no problem of any kind.
Just to let you know in case you missed that ;-)
My 2 ยข
--
Jean-Paul Argudo
www.Argudo.o
