Re: database design questions
| От | hubert depesz lubaczewski |
|---|---|
| Тема | Re: database design questions |
| Дата | |
| Msg-id | 9e4684ce0604050033w321a816hac33f4b9c7e16736@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: database design questions (Ottavio Campana <ottavio@campana.vi.it>) |
| Список | pgsql-general |
On 4/4/06, Ottavio Campana <ottavio@campana.vi.it> wrote:
when coding in plpgsql you have to use dynamic queries to use this kind of thing. this - by itself - is not bad. but it has certain performance penalty when compared to standard queries.
i think reading plpgsql's manual about "execute" is the best one can do about it :)
best regards
depesz
hubert depesz lubaczewski wrote:
> 2) do you think it's possible in a plpgsql procedure select the name of
> a table into a variable and use that variable in the query?
> possible, but not really good way. read about 'execute' in plpgsql.
why isn't it good?
I mean, from my point of view is like a function accepting a pointer. In
many languages it is used.
when coding in plpgsql you have to use dynamic queries to use this kind of thing. this - by itself - is not bad. but it has certain performance penalty when compared to standard queries.
i think reading plpgsql's manual about "execute" is the best one can do about it :)
best regards
depesz
В списке pgsql-general по дате отправления: