Re: SQL99 functions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SQL99 functions
Date
Msg-id 8783.962095875@sss.pgh.pa.us
Whole thread Raw
In response to SQL99 functions  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
List pgsql-hackers
Thomas Lockhart <lockhart@alumni.caltech.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.  SurelySELECT 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


pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Big 7.1 open items
Next
From: Philip Warner
Date:
Subject: Re: Proposal: More flexible backup/restore via pg_dump