Re: pgaccess: I can't save a view

Поиск
Список
Период
Сортировка
От sferac@bo.nettuno.it
Тема Re: pgaccess: I can't save a view
Дата
Msg-id Pine.LNX.3.96.980313173258.1783F-100000@nero
обсуждение исходный текст
Список pgsql-interfaces
Hi,
There's an error generated by parser when I try to save a view as:

          SELECT * FROM table_name WHERE column_name = 'VALUE'

If I push <Save query definition> button I have this error message:

           -----------------------------------------------
                        error defining view
             ERROR: parser: parse error at or near 'VALUE'
           -----------------------------------------------
If I push <Execute query> button it works, but I can't save it as a view

... it saves views with only if is not present the WHERE clause, like this:

             SELECT comlumn_1 FROM table_name

                                                            Ciao, Jose'



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

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: [QUESTIONS] PostgreSQL 6.3
Следующее
От: Constantin Teodorescu
Дата:
Сообщение: Re: [INTERFACES] Re: pgaccess: I can't save a view