From: | "Peter Alberer" <h9351252(at)obelix(dot)wu-wien(dot)ac(dot)at> |
---|---|
To: | "'sferriol'" <sylvain(dot)ferriol(at)imag(dot)fr>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: dynamic views |
Date: | 2004-02-25 09:56:56 |
Message-ID: | 000301c3fb85$b83a0c60$5be0d089@ekelhardt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sorry i forgot to mention:
-that you need pg 7.3 for the set-returning function feature.
-how to select from the function:
select * from _YOUR_FUNCTION(PARAMETER);
and NOT:
select _YOUR_FUNCTION(PARAMETER);
>-----Ursprüngliche Nachricht-----
>Von: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
>owner(at)postgresql(dot)org] Im Auftrag von sferriol
>Gesendet: Dienstag, 24. Februar 2004 17:30
>An: pgsql-general(at)postgresql(dot)org
>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 '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
>
>
>---------------------------(end of
broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
majordomo(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | V i s h a l Kashyap @ [Sai Hertz And Control Systems] | 2004-02-25 10:05:11 | Re: select statement against pg_stats returns inconsistent |
Previous Message | Peter Alberer | 2004-02-25 09:54:56 | Re: dynamic views |