Re: SQL99 functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SQL99 functions
Date: 2000-06-27 08:51:15
Message-ID: 8783.962095875@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> writes:
> I see mention in SQL99 of function definitions which can have IN, OUT,
> and INOUT arguments. Any thoughts on how this could be supported in
> Postgres?

I noticed that but haven't quite figured out how it's supposed to fit
into the SQL worldview at all. Surely
SELECT foo(x) FROM table
shouldn't silently mutate into an UPDATE depending on how foo() is
declared. Exactly where is a function with OUT args useful in SQL?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2000-06-27 08:53:10 Re: Big 7.1 open items
Previous Message Tom Lane 2000-06-27 08:38:10 Re: Makefile for parser