Search Postgresql Archives

Re: plpgsql: How to modify a field in an array of records

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



--
Dirk Mika
Software Developer

mika:timing GmbH
Strundepark - Kürtener Str. 11b
51465 Bergisch Gladbach
Germany

fon +49 2202 2401-1197
dirk.mika@xxxxxxxxxxxxx
www.mikatiming.de

AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
Geschäftsführer: Harald Mika, Jörg Mika



## How2Use
## the ChampionChip by mika:timing
## https://youtu.be/qfOFXrpSKLQ
Am 02.07.19, 15:53 schrieb "Tom Lane" <tgl@xxxxxxxxxxxxx>:

    Yeah, that seems like it ought to work, and ideally it would.  But plpgsql
    doesn't currently have support for nested field-of-array-element or
    element-of-record-field assignments.  (I've looked briefly at this in the
    past, and it doesn't seem impossible, but it's definitely not trivial
    either.)

Ah, that explains the error message, of course. And I thought it was actually a matter of correct syntax. :-)

    You'll have to do some kind of workaround like assigning the whole array
    element to a temp variable, fixing the field in the temp variable, then
    assigning back :-(

I tried that and it seemed to work. There is no error message and the function seems to do the right thing. ;-)

Dirk





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux