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
Список
Дерево обсуждения
Re: [INTERFACES] pgaccess: I can't save a view Constantin Teodorescu <teo@flex.ro>
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  button I have this error message:

           -----------------------------------------------
                        error defining view
             ERROR: parser: parse error at or near 'VALUE'
           -----------------------------------------------
If I push  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
Дата:
FAQ