Functions with more than 32 parameters

Поиск
Список
Период
Сортировка
От Oisin Glynn
Тема Functions with more than 32 parameters
Дата
Msg-id 001c01c50f1e$31f12550$0300a8c0@bowdoin
обсуждение исходный текст
Ответ на Understanding EXPLAIN ANALYZE output  ("Ed L." <pgsql@bluepolka.net>)
Ответы Re: Functions with more than 32 parameters  (David Fetter <david@fetter.org>)
Список pgsql-general
Hi,

I am trying to keep database access encapsulated in functions from an insert
and update point of view so as all of the applications writing to the
database are using the same functions/statements.

My problem is I was creating functions to do inserts/updates and now I have
a table with more than 32 columns and the functions seem to only want to
have 32 parameters?

Is there any way around this?

I have used stored procedures in this way with Oracle/SQL server before.Or
is there another strategy I could use?

I am using Windows 2000 Postgres 8.0.1 if it makes a difference

Thanks in advance,
Oisin


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

Предыдущее
От: "Ed L."
Дата:
Сообщение: Re: Understanding EXPLAIN ANALYZE output
Следующее
От: "Ed L."
Дата:
Сообщение: Re: Understanding EXPLAIN ANALYZE output