Re: Tuning queries inside a function

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Tuning queries inside a function
Дата
Msg-id 42765977.4020906@commandprompt.com
обсуждение исходный текст
Ответ на Re: Tuning queries inside a function  (Mike Nolan <nolan@gw.tssi.com>)
Ответы Re: Tuning queries inside a function  (Mike Nolan <nolan@gw.tssi.com>)
Список pgsql-general
Mike Nolan wrote:
>>select * from foo('bar','debug')
>
>
> But how do I do that inside a pl/pgsql function?  'select into' doesn't
> seem to work properly.


You would have to code it. For example:

IF $2 = ''debug'' THEN:
>
>
>>I would have to check be able to include a timestamp at the beginning
>>of each notice.
>
>
> You can do that from the config file, but it only gives the time to the
> nearest second, which may not be a fine enough time interval.
> --
> Mike Nolan


--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedication Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [Dbdpg-general] Re: 'prepare' is not quite schema-safe
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 7.3.9 Install Question - init.d/postgresql error?