Re: Error in crosstab using date_trunc - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Error in crosstab using date_trunc
Date
Msg-id dcc563d10912060834t669f965bl6f292c91dc0c3fd@mail.gmail.com
Whole thread Raw
In response to Re: Error in crosstab using date_trunc  (José María Terry Jiménez <jtj@tssystems.net>)
List pgsql-general
2009/12/6 José María Terry Jiménez <jtj@tssystems.net>:
>
> Thank you very much. This worked, also worked with ' instead $outer$ BUT
> escaping the ' in minute with two of them  ' 'minute' '.
>
> What does $outer$ or when i must use it?

It's a type of quoting...  Take a look here:

http://www.postgresql.org/docs/8.3/static/sql-syntax-lexical.html

section 4.1.2.2 for more info.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: numeric cast oddity
Next
From: Dennis Gearon
Date:
Subject: Re: using column as 'mutex'