| From: | Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Dynamic PL/pgSQL select query: value association propblem |
| Date: | 2018-02-16 23:49:56 |
| Message-ID: | f15c54a2-7299-9684-e7be-ffde281b8481@gelassene-pferde.biz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 02/16/18 14:47, Thiemo Kellner, NHC Barhufpflege wrote:
> Thanks for answering.
>
> Zitat von Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:
>
>> Why you don't create query like
>>
>> EXECUTE 'SELECT xxx FROM TAB WHERE A = $1.x AND B = $1.y' USING NEW;
>
> I shall try. This would be the direct way, but I doubt the placeholder
> $1 can be a record.
It's terrific! This works! :-) :-) :-)
--
+49 (0)1578-772 37 37
+41 (0)78 947 36 21
SIP/iptel.org: thiemo.kellner
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0xCA167FB0E717AFFC
| Attachment | Content-Type | Size |
|---|---|---|
| thiemo.vcf | text/x-vcard | 693 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Olegs Jeremejevs | 2018-02-16 23:50:48 | Rationale for PUBLIC having CREATE and USAGE privileges on the schema "public" by default |
| Previous Message | Melvin Davidson | 2018-02-16 23:44:58 | Re: gathering ownership and grant permissions |