Re: [Artanis] Working with PostgresQL

[Nala Ginrut]

Hi ison!
It's my mistake, according to SQL standard, string literals are always
surrounded by single quotation marks.
I've fixed it in dbb5876bc5ddb457c94f304a211613d74993e396.
Please try it again.

Best regards.

ison writes:

> 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?


-- 
GNU Powered it
GPL Protected it
GOD Blessed it
HFG - NalaGinrut
Fingerprint F53B 4C56 95B5 E4D5 6093 4324 8469 6772 846A 0058

signature.asc
Description: PGP signature