Re: request for sql3 compliance for the update command

On Thu, Feb 20, 2003 at 09:31:21AM -0500, Tom Lane wrote:
> about.  I originally understood Dave to be asking for parens to be
> allowed around individual target column names, which seems a useless
> frammish to me.  What Bruce has pointed out is that a syntax that lets
> you assign multiple columns from a single rowsource would be an actual
> improvement in functionality, or at least in convenience and efficiency.
> (It would also be a substantial bit of work, which is why I think this
> isn't what Dave was offering a quick patch to do...)  What I'd like to
> know right now is which interpretation Informix actually implements.

Informix syntax is listed on 
http://www-3.ibm.com/software/data/informix/pubs/library/visionary/infoshelf/sqls/01start.fm.html#156200

It's more than just parens IMO. :-)

Michael
-- 
Michael Meskes
Email: Michael@Fam-Meskes.De
ICQ: 179140304
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!