Date: Tue, 23 Jul 2024 22:11:21 +0200
From: Vincent Veyron <vv.lists@wanadoo.fr>
To: Dan Kortschak <dan+pgsql@kortschak.io>
Cc: pgsql-general@postgresql.org
Subject: Re: re-novice coming back to pgsql: porting an SQLite update
 statement to postgres
Message-Id: <20240723221121.51f2b3872d0ebfc36a6fa8ff@wanadoo.fr>
In-Reply-To: <1aea530e4c96109b91fdde53a29e38beb625dc77.camel@kortschak.io>
References: <1aea530e4c96109b91fdde53a29e38beb625dc77.camel@kortschak.io>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/20240723221121.51f2b3872d0ebfc36a6fa8ff%40wanadoo.fr>
Precedence: bulk

On Mon, 15 Jul 2024 20:31:13 +0000
Dan Kortschak <dan+pgsql@kortschak.io> wrote:

> My question is where would be the best place for me to looks to learn
> about how to implement a port of this SQLite? and what would broadly be
> the most sensible approach to take (to narrow down what I need to read
> through in learning)?
>=20

This is the goto page for anything SQL :
https://www.postgresql.org/docs/current/sql-commands.html

For DateTime types :
https://www.postgresql.org/docs/current/datatype-datetime.html

For JSON types :
https://www.postgresql.org/docs/current/datatype-json.html

If your query works in SQLite, all you have to do is read those, and try to=
 port; if it fails, read them again. Also search the archives of the pgsql-=
general list, many answers in there


--=20
					Bien =E0 vous, Vincent Veyron=20

https://compta.libremen.com
Logiciel libre de comptabilit=E9 g=E9n=E9rale en partie double