Scott Yohonn wrote:
> Jean-Paul,
>
> Thanks! This did work. The output put the name of the function
> (get_table_count) as the header. How would I display the name of the table
> that I am requesting the row count of?
The only way I know is to alias the output in the query calling 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 versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
