Re: PL/PGSQL - How to pass in variables?

Поиск
Список
Период
Сортировка
От Jean-Paul Argudo
Тема Re: PL/PGSQL - How to pass in variables?
Дата
Msg-id 44677BED.7080803@argudo.org
обсуждение исходный текст
Ответ на PL/PGSQL - How to pass in variables?  ("Scott Yohonn" <syohonn@gmail.com>)
Список pgsql-sql
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


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Jaime Casanova"
Дата:
Сообщение: Re: PL/PGSQL - How to pass in variables?
Следующее
От: Emi Lu
Дата:
Сообщение: Re: Find min and max values across two columns?