Re: Error in crosstab using date_trunc

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: José María Terry Jiménez <jtj(at)tssystems(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error in crosstab using date_trunc
Date: 2009-12-06 16:34:05
Message-ID: dcc563d10912060834t669f965bl6f292c91dc0c3fd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/12/6 José María Terry Jiménez <jtj(at)tssystems(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2009-12-06 16:47:31 Re: using column as 'mutex'
Previous Message Tom Lane 2009-12-06 15:10:36 Re: numeric cast oddity