Re: [GENERAL] Using function returning multiple values in a select

2015-10-24 Thread Adrian Klaver
On 10/24/2015 12:37 PM, Lele Gaifax wrote: Adrian Klaver writes: An actual working example that shows exactly what you want to achieve would help. Mainly where does the base price originate? A product has a base price (and maybe a base discount), but that may be overridden by particular rule

Re: [GENERAL] Using function returning multiple values in a select

2015-10-24 Thread Lele Gaifax
Adrian Klaver writes: > An actual working example that shows exactly what you want to achieve would > help. Mainly where does the base price originate? A product has a base price (and maybe a base discount), but that may be overridden by particular rules based on the customer, on the product typ

Re: [GENERAL] Using function returning multiple values in a select

2015-10-24 Thread Adrian Klaver
On 10/24/2015 10:56 AM, Lele Gaifax wrote: Hi all, I have a function that returns multiple values, computing them from the input parameters, and I need to use it within an existing query. Say I have the following table: CREATE TABLE products ( id SERIAL NOT NULL, description VARCH

[GENERAL] Using function returning multiple values in a select

2015-10-24 Thread Lele Gaifax
Hi all, I have a function that returns multiple values, computing them from the input parameters, and I need to use it within an existing query. Say I have the following table: CREATE TABLE products ( id SERIAL NOT NULL, description VARCHAR(64), PRIMARY KEY (id) ) and the foll