From: | Maciek Sakrejda <msakrejda(at)truviso(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Nested literal parsing rules? |
Date: | 2010-09-22 23:11:17 |
Message-ID: | AANLkTinuFbCGbOqUAa9-rwgxV7CFib=Wa4Kp6Cm=TT0W@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> The record and array escaping rules are here:
> http://www.postgresql.org/docs/9.0/static/rowtypes.html#AEN7091
> http://www.postgresql.org/docs/9.0/static/arrays.html#ARRAYS-IO
> and I think the hstore rules are spelled out in the docs for that
> contrib module.
Thanks, that helped a lot. I think I was going off of what I read in
Section 8.15.2, but 8.15.5 is much more helpful. Should have kept
reading. And I just realized I'd been doubling backslashes too many
times for standard_conforming_strings, which certainly didn't help
things.
> Neither record nor hstore quote exactly like arrays, so that's probably
> part of your problem. (No doubt it'd be better if they did, but we've
> got too much historical baggage :-()
I understand completely.
Thanks for your help,
---
Maciek Sakrejda | System Architect | Truviso
1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2010-09-22 23:28:21 | What was new in 8.4 & 8.3? |
Previous Message | Tom Lane | 2010-09-22 21:51:25 | Re: Can psql show the column type of a result ? |