From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
---|---|
To: | "Curtis Stecke" <cstecke(at)interlegis(dot)com>, <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #5499: SQL syntax bug |
Date: | 2010-06-11 16:51:12 |
Message-ID: | 4C12233002000025000321DA@gw.wicourts.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
"Curtis Stecke" <cstecke(at)interlegis(dot)com> wrote:
> Inserting text that starts with or ends with a dollar sign ($) is
> impossible. Documentation is not clear on how to do this as well.
Works for me. Care to give an example of your problem?
test=# create table t1 (c1 text);
CREATE TABLE
test=# insert into t1 values ('$sometext');
INSERT 0 1
test=# insert into t1 values ('sometext$');
INSERT 0 1
test=# insert into t1 values ('$sometext$');
INSERT 0 1
test=# select * from t1;
c1
------------
$sometext
sometext$
$sometext$
(3 rows)
-Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Dimitri Fontaine | 2010-06-11 18:46:22 | Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading |
Previous Message | Curtis Stecke | 2010-06-11 16:41:47 | BUG #5499: SQL syntax bug |