Re: Nested literal parsing rules?

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

In response to

Responses

Browse pgsql-general by date

  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 ?