Re: BUG #5499: SQL syntax bug

"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