Re: [h2] working around differences with h2 PSQL compatibilty

2024-04-07 Thread Andreas Reichel
Greetings!

You could use JSQLParser to parse your query and then transpile/rewrite
it into the specific dialect.
If you would like to give me a Query sample then I will happily assist
you with a template.

Cheers
Andreas

On Sun, 2024-04-07 at 08:27 -0700, broccolai wrote:
> hi!
>
> I'm offering psql and h2 options in my software, as well as using h2
> in my tests. But I'm having an issue when trying to store json data.
> H2 requires "FORMAT JSON" in the value for json but this syntax isn't
> allowed in PSQL. I'm trying to use the same queries between both
> which has been fine for almost everything until this.
>
> Anyone have any ideas?
> --
> You received this message because you are subscribed to the Google
> Groups "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it,
> send an email to h2-database+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/h2-database/790f0e5f-1900-40b9-a886-a5aeeb85657bn%40googlegroups.com
> [1].


[1] 
https://groups.google.com/d/msgid/h2-database/790f0e5f-1900-40b9-a886-a5aeeb85657bn%40googlegroups.com

https://groups.google.com/d/msgid/h2-database/790f0e5f-1900-40b9-a886-a5aeeb85657bn%40googlegroups.com?utm_medium=email_source=footer

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/d75e69e60c940a1263c8b4a6fe8786ed19730cfc.camel%40manticore-projects.com.


[h2] working around differences with h2 PSQL compatibilty

2024-04-07 Thread broccolai
hi! 

I'm offering psql and h2 options in my software, as well as using h2 in my 
tests. But I'm having an issue when trying to store json data. H2 requires 
"FORMAT JSON" in the value for json but this syntax isn't allowed in PSQL. 
I'm trying to use the same queries between both which has been fine for 
almost everything until this.

Anyone have any ideas?

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/790f0e5f-1900-40b9-a886-a5aeeb85657bn%40googlegroups.com.