Re: final patch - plpgsql: for-in-array

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Jaime Casanova <jaime(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: final patch - plpgsql: for-in-array
Date: 2010-11-18 20:00:04
Message-ID: AANLkTimgECqB77DrLbsgfMxxrzJZz0cixoYFoU=b5NvQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2010/11/18 Andrew Dunstan <andrew(at)dunslane(dot)net>:
>
>
> On 11/18/2010 02:39 PM, Pavel Stehule wrote:
>>
>> 2010/11/18 Andrew Dunstan<andrew(at)dunslane(dot)net>:
>>>
>>> On 11/18/2010 02:17 PM, Pavel Stehule wrote:
>>>>
>>>>  -only a few people use FOR IN SELECT UNNEST for iteration over array.
>>>
>>> How on earth do you know that? I use it a lot and I was just
>>> demonstrating
>>> it to a client yesterday, and I'm quite sure he will use it a lot too. I
>>> bet
>>> I'm far from alone.
>>>
>> how much people are active readers and writers in pg_hackers like you? :)
>>
>> I didn't say so nobody use it. You, me, David. But I really didn't see
>> this pattern here in real applications.
>>
>
> Lots of people are told to use it on IRC. Trust me, it's getting well known.

can be. but people on IRC are not representative.

I have about 10 courses of PL/pgSQL per year (about 100 people) -
almost all my students newer visited IRC. 30% of my students has a
problem to write a bublesort or some little bit complex code. I meet
this people. There can be a language barrier or some laziness. Really
it is surprisingly how too less people are interesting about coding.
This people has own problems, and usually uses a most classic patter
that know from programming languages.

These peoples are "normal" and typical. Some courses I have under some
big Czech agency - so there are people from banks, industry. Actually
only I do a courses of PLpgSQL in Czech language - so I think I know
what people use. For example - only a few people know and use a
generate_series functions.

sorry for offtopic :)

Pavel

>
> cheers
>
> andrew
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2010-11-18 20:11:32 Re: final patch - plpgsql: for-in-array
Previous Message Pavel Stehule 2010-11-18 19:46:28 Re: final patch - plpgsql: for-in-array