Problem with an SQL function

From: chris(dot)gamble(at)CPBINC(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with an SQL function
Date: 2002-06-14 23:32:29
Message-ID: 00CA54A79070D411A9E20090273CEF1C14F335@inet1.cpbinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2002-06-15 00:12:10 Re: I must be blind...
Previous Message Tony Carter 2002-06-14 22:31:40 Re: large database on postgres