Lambda expressions in SQL

From: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
To:
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Lambda expressions in SQL
Date: 2005-03-07 18:20:56
Message-ID: ED4E30DD9C43D5118DFB00508BBBA76EB16622@neptun.sonorys.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Coming from functional programming, I often wish to write something like
that:

(LAMDA "expesiveFcn"(x y z) as exfcn
update "Tbl5" SET "Column" = exfcn
)

In this case "expensiveFcn" is VOLATILE...

Is there a way?

At least: substituting the lambda by a select doesn't work with update as
subquery

Browse pgsql-sql by date

  From Date Subject
Next Message PFC 2005-03-07 18:41:25 Re: Links between rows in a table
Previous Message John McGough 2005-03-07 16:22:15 SQL query help?