pg equivalent to MS SQL exec command

Поиск
Список
Период
Сортировка
От Ugly Hippo
Тема pg equivalent to MS SQL exec command
Дата
Msg-id 20020306163629.93849.qmail@web21207.mail.yahoo.com
обсуждение исходный текст
Ответы Re: pg equivalent to MS SQL exec command  ("Josh Berkus" <josh@agliodbs.com>)
Список pgsql-novice
Hi,

I have moved a database from MS SQL to PG and am now
trying to move my stored procedures.  I have created a
PG function and am trying to figure out how to execute
it without using a trigger.  In MS, I would type 'exec
stored_procedure_name'.  Is there an equivalent in PG.
 I have tried the 'execute' command but that seems to
work only within a function.  I wish to execute this
function when I feel like it, not on a fixed schedule.
 Did I miss something in the documentation?

Thanks,
Troy

______________________________________________________________________
Find, Connect, Date! http://personals.yahoo.ca

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: index item size 4496 exceeds maximum 2713
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Re: referential integrity for insert