| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Frank jansen *EXTERN*" <jansen(at)fumarium(dot)de>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Concatenate |
| Date: | 2010-03-24 13:27:13 |
| Message-ID: | 28458CC8A2865245BF47BABF785E03E31CBAA3@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Frank jansen wrote:
> can you help me with this tricky concat i have?
> I have a function with an execute statement, one line of it doing an md5
> hash of some concatenated xml paths with values. I cannot get this one
> work, postgres is always complaing about some things, like: "functions
> and operators can take at most one set argument"
>
> EXECUTE'
> ...
> md5_hash=md5(unnest(xpath(''/foo/bar'',xml_content::xml))::text) ||
> (unnest(xpath(''/foo/bar2'',xml_content::xml))::text)
> ....
That's too little, can you show more of the statement?
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2010-03-24 13:41:03 | Re: Concatenate |
| Previous Message | Thom Brown | 2010-03-24 13:09:20 | Re: Out of Memory during Insert |