Hi, Firstly; I'm not a developer, but a business developer and statistics guy. This means that I'm happy using "basic" selects to gather information for analysis.
One thing that could really efficiate my work is using variables, let's say I have a table with different orders; |customer_id|productid|price| What I really want is to create a general query where I could easily substitute productid. // declare variable --> productid = 10 select count(distinct customer_id), avg(price) from customer_table where productid=<insert variable> \\ Is there a way of doing this without getting involved with heavy programming? Thank you and applogies if this is a ridicioulus question! -- View this message in context: http://postgresql.1045698.n5.nabble.com/Using-variables-in-select-tp4692865p4692865.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
