From: | A_Schnabel(at)t-online(dot)de (Andre Schnabel) |
---|---|
To: | <peter(at)alberer(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: View with parameters ? |
Date: | 2001-07-24 17:53:36 |
Message-ID: | 000b01c11469$90d0a900$0201a8c0@aschnabel.homeip.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
views don't take parameters. But if you include the custumerid in your view,
you can simply select a single row.
----- Original Message -----
From: Peter Alberer
To: pgsql-novice(at)postgresql(dot)org
Sent: Tuesday, July 24, 2001 3:55 PM
Subject: [NOVICE] View with parameters ?
Hi there,
i wanted to know if there is a possibility to construct something like a
view or procedure with parameters that returns rows. for example i would
like to create a procedure that returns details about a customer. i imagine
something like a procedure or view called user_details that takes a user_id
as argument and returns the details for that specific customer as one row.
the examples of functions or views i saw for postgres had no parameters (the
views) or did return single values (the functions)
am i missing something ?
tia,
peter(at)alberer(dot)com
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
From | Date | Subject | |
---|---|---|---|
Next Message | GH | 2001-07-25 07:40:19 | Re: ANSI SQL |
Previous Message | Peter Alberer | 2001-07-24 13:55:38 | View with parameters ? |