Re: Stored Procedure examples

Поиск
Список
Период
Сортировка
От Paul Lambert
Тема Re: Stored Procedure examples
Дата
Msg-id 45D397A0.6050906@autoledgers.com.au
обсуждение исходный текст
Ответ на Re: Stored Procedure examples  (Paul Lambert <paul.lambert@autoledgers.com.au>)
Список pgsql-general
Paul Lambert wrote:
> Walter Vaughan wrote:
>>
>> This may not help, but I noticed using pgAdminIII, you can create a
>> procedure or a function, but they seem to have the same creation
>> interface and use the same icon.
>>
>
> A procedure is a function that returns null.

That should have said void of course.

>
> You'll note if you create a procedure under pgAdminIII, it gets saved
> under functions, not under procedures.
>
> I spent a couple of minutes a few days back trying to find all the
> procedures I'd just created only to note that they were in fact sitting
> under functions. I couldn't see them under procedures, but when I tried
> to create them again I was told they already existed... it was hair
> pulling stuff there for a couple of minutes.
>


--
Paul Lambert
Database Administrator
AutoLedgers


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

Предыдущее
От: Paul Lambert
Дата:
Сообщение: Installing on weendoze vista.
Следующее
От: "carter ck"
Дата:
Сообщение: How to create an archive for old records?