[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")
prints:
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?
- [Artanis] Working with PostgresQL,
ison <=