Re: plpgsql.consistent_into - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: plpgsql.consistent_into
Date
Msg-id CAFj8pRCQVFyNxJ9NRePPRLQoFxLCWrc=MHJDgJ-2kbJZXcvbHA@mail.gmail.com
Whole thread Raw
In response to Re: plpgsql.consistent_into  (Marko Tiikkaja <marko@joh.to>)
List pgsql-hackers
Hello


2014/1/14 Marko Tiikkaja <marko@joh.to>
On 1/14/14 1:28 PM, Pavel Stehule wrote:
I prefer subquery only syntax - a := (some) or (a,b,c) = (some a,b,c) with
possible enhancing for statements with RETURNING

a advance is compatibility with DB2 (SQL/PSM) syntax - and this code is
written now - it is done in my sql/psm implementation

Are you saying that DB2 supports the multi-variable assignment?  I couldn't find any reference suggesting that, can you point me to one?

I was wrong - it is different syntax - it is SQL/PSM form - db2 supports SET var=val, var=val, ...

 http://postgres.cz/wiki/Basic_statements_SQL/PSM_samples

Regards

Pavel



Regards,
Marko Tiikkaja

pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: GIN improvements part2: fast scan
Next
From: Tom Lane
Date:
Subject: Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance