On Wed, 29 Nov 2006 18:38:22 +0530, "Merlin Moncure" <[EMAIL PROTECTED]> wrote:
> On 11/29/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>> Hello friends,
>> I have a view defined as:-
>>
>> CREATE VIEW vivek_testview AS SELECT vivek_test.* , users.username AS
> name from users, vivek_test wh
On 11/29/06, Bernd Helmle <[EMAIL PROTECTED]> wrote:
> no, queries using * are expanded when the plan is created. for views,
> the plan is created when you create the view (also the original query
> string to create the view is not stored). however, you could however
> create a function that re
On 11/29/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello friends,
I have a view defined as:-
CREATE VIEW vivek_testview AS SELECT vivek_test.* , users.username AS name from
users, vivek_test where vivek_test.username=users.username;
Now, when I add a new column in vivek_test, I cant see
Hello friends,
I have a view defined as:-
CREATE VIEW vivek_testview AS SELECT vivek_test.* , users.username AS name from
users, vivek_test where vivek_test.username=users.username;
Now, when I add a new column in vivek_test, I cant see the new column in the
view. Currently we have to drop the
Hello friends,
I have a view defined as:-
CREATE VIEW vivek_testview AS SELECT vivek_test.* , users.username AS name from
users, vivek_test where vivek_test.username=users.username;
Now, when I add a new column in vivek_test, I cant see the new column in the
view. Currently we have to drop the
eneral-
>[EMAIL PROTECTED] Im Auftrag von sferriol
>Gesendet: Dienstag, 24. Februar 2004 17:30
>An: [EMAIL PROTECTED]
>Betreff: [GENERAL] dynamic views
>
>hello
>is it possible with postgres 7.2 or more, to define a dynamic view.
>For example, i have a table with a column '
cht-
>Von: [EMAIL PROTECTED] [mailto:pgsql-general-
>[EMAIL PROTECTED] Im Auftrag von sferriol
>Gesendet: Dienstag, 24. Februar 2004 17:30
>An: [EMAIL PROTECTED]
>Betreff: [GENERAL] dynamic views
>
>hello
>is it possible with postgres 7.2 or more, to define a dynamic vie
On Tuesday 24 February 2004 16:29, sferriol wrote:
> hello
> is it possible with postgres 7.2 or more, to define a dynamic view.
> For example, i have a table with a column 'user'
> and i want to define a view which gives infomrations from different
> tables but the user has to specifie the 'user'
hello
is it possible with postgres 7.2 or more, to define a dynamic view.
For example, i have a table with a column 'user'
and i want to define a view which gives infomrations from different
tables but the user has to specifie the 'user' parameter when using a
select to the view
sylvain
--
