Skip site navigation (1) Skip section navigation (2)

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: (view raw or whole 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


pgsql-hackers by date

Next:From: Hiroshi InoueDate: 2000-06-27 08:53:10
Subject: Re: Big 7.1 open items
Previous:From: Tom LaneDate: 2000-06-27 08:38:10
Subject: Re: Makefile for parser

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group