Thread: BUG #5499: SQL syntax bug

The following bug has been logged online:

Bug reference:      5499
Logged by:          Curtis Stecke
Email address:      cstecke@interlegis.com
PostgreSQL version: 8.4
Operating system:   Windows Xp
Description:        SQL syntax bug
Details:

Inserting text that starts with or ends with a dollar sign ($) is
impossible. Documentation is not clear on how to do this as well.

"Curtis Stecke" <cstecke@interlegis.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