Kashmira Patel (kupatel) wrote:
Hi all, Is it possible to create views that take parameters?
Basically, I have to create some very complex historical reports, and
as of now I am using temporary tables to store intermediate query
results. I calculate values based on the content of these temporary
Hi all,
Is it possible to create views that take parameters? Basically, I have to
create some very complex historical reports, and as of now I am using temporary
tables to store intermediate query results. I calculate values based on the
content of these temporary tables and use them in the f
Hi
CREATE VIEW user_stuff ...select comand that displays what you want... ;
This might be what you want ?:-)
CREATE VIEW user_stuff
SELECT username AS "Username",userpassword AS
"Pass/Attribute",startdate::TEXT AS "Date/Value"
FROM user
UNION SELECT
user.username,userdetail.attributename,use
At 10:59 AM 6/6/03, Damien Dougan wrote:
I was wondering if it is possible to create a table view based on a table
which is effectively an "attribute list".
For example, suppose I have two tables:
CREATE TABLE user
(
userid integer,
username character varying,
userpassword character varying,
Hi All,
(I'm sure I'm not the first person to want to do this, but I didn't see any
mention of it in the FAQ or developers FAQ nor in the docs - if I've missed
something, a gentle pointer will be fine :)
I was wondering if it is possible to create a table view based on a table
which is effec
