[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Artanis] Working with PostgresQL

From: ison
Subject: [Artanis] Working with PostgresQL
Date: Thu, 3 Oct 2019 18:32:21 -0600
User-agent: NeoMutt/20180716

I'm trying to use Artanis with PostgresQL and it seems that it has
some bugs with inserting/reading strings from the database.
I noticed that integers can be inserted and read, but not strings.
After investingating the issue I think it boils down the usage of
"~s" in how Artanis formats strings (in files ssql.scm and fprm.scm)

Which results in the string being printed with double quotes.

For instance using the "where" function in Artanis such as:
(where #:name "foo")
 where name="foo"

However, this results in an error in PostgresQL because it doesn't
like double quotes. For example, the SQL query:
SELECT * FROM mytable WHERE name="foo";
is an error on PostgresQL. But
SELECT * FROM mytable WHERE name='foo';
is the right way to do it.

Is there any way to work around this?

reply via email to

[Prev in Thread] Current Thread [Next in Thread]