Re: join and dynamic view

Поиск
Список
Период
Сортировка
От Tomasz Myrta
Тема Re: join and dynamic view
Дата
Msg-id 3DFF355B.4000905@klaster.net
обсуждение исходный текст
Ответ на Re: join and dynamic view  (Christoph Haller <ch@rodos.fzk.de>)
Ответы Upgrade question - was Re: join and dynamic view  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
Список pgsql-sql
Gary Stainburn wrote:

>
> I found that the compile error complaining about the 'OR' was on the
>
> CREATE OR REPLACE FUNCTION
>
> line.  I removed the 'OR REPLACE' and everything worked fine.

OR REPLACE is since postgres 7.2

>
>
> Also I had to change the returns to 'opaque' and 'return 0' to 'return 
> null'

In this case it's ok to "return null", but if you create "before" 
trigger you shoud "return new", because "return null" forces postgres 
not to insert any data.

Tomasz Myrta




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

Предыдущее
От: Gary Stainburn
Дата:
Сообщение: Re: join and dynamic view
Следующее
От: Gary Stainburn
Дата:
Сообщение: Upgrade question - was Re: join and dynamic view