Douglas Little wrote:
> I need to evaluate an expression that I have stored in a table, and not sure
> how to force evaluation
> of a column value.
[...]
> The pass/fail query looks something like this
>
> Update testscore
> Set metricstatus = case when table_a.col_a = table_b.col_bthen 'P
On 12/18/2012 08:50 AM, Merlin Moncure wrote:
> On Tue, Dec 18, 2012 at 10:03 AM, Little, Douglas
> Anybody have any comments?
>
> probably you need a pl/pgsql function which wraps your argument table,
> builds the query, and invokes the query with EXECUTE.
For an example see slide 19 here:
h
On Tue, Dec 18, 2012 at 10:03 AM, Little, Douglas wrote:
> Hi,
>
> ** **
>
> I need to evaluate an expression that I have stored in a table, and not
> sure how to force evaluation of a column value.
>
> ** **
>
> Some background. This is a generic testing application that we’re using
>
Hi,
I need to evaluate an expression that I have stored in a table, and not sure
how to force evaluation of a column value.
Some background. This is a generic testing application that we're using to
test source to target ETL's.
The specifics of the test expression depend on the actual tables