Thread: Problem with an SQL function

Is it possible to define the following in language='SQL' ?

select (69.1 * $1 - $2) as x, (53 * $3 - $4) as y;
select sqrt(x * x + y * y) as distance;

I was trying to create this but keep getting the error that x does not
exist...

On Fri, 14 Jun 2002 chris.gamble@CPBINC.com wrote:

> Is it possible to define the following in language='SQL' ?
>
> select (69.1 * $1 - $2) as x, (53 * $3 - $4) as y;
> select sqrt(x * x + y * y) as distance;
>
> I was trying to create this but keep getting the error that x does not
> exist...

I don't think you can do it as the above, but for the simple
example above, you can probably make it one query with a
subselect in from.
select sqrt(x*x+y*y) as distance from
 (select (69.1 * $1 - $2) as x, (53 * $3 - $4) as y) as foo;