| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Marko Tiikkaja <marko(at)joh(dot)to> |
| Cc: | Marti Raudsepp <marti(at)juffo(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: plpgsql.consistent_into |
| Date: | 2014-01-14 15:39:33 |
| Message-ID: | CAFj8pRCQVFyNxJ9NRePPRLQoFxLCWrc=MHJDgJ-2kbJZXcvbHA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello
2014/1/14 Marko Tiikkaja <marko(at)joh(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-01-14 15:39:35 | Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance |
| Previous Message | Alexander Korotkov | 2014-01-14 15:35:25 | Re: GIN improvements part2: fast scan |