Feedback-ID: i76984098:Fastmail
Message-ID: <2f11b2ba-3182-492a-ab46-23cfa5ec913c@aklaver.com>
Date: Tue, 23 Jul 2024 13:35:42 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: re-novice coming back to pgsql: porting an SQLite update
 statement to postgres
To: Vincent Veyron <vv.lists@wanadoo.fr>,
 Dan Kortschak <dan+pgsql@kortschak.io>
Cc: pgsql-general@postgresql.org
References: <1aea530e4c96109b91fdde53a29e38beb625dc77.camel@kortschak.io>
 <20240723221121.51f2b3872d0ebfc36a6fa8ff@wanadoo.fr>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <20240723221121.51f2b3872d0ebfc36a6fa8ff@wanadoo.fr>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/2f11b2ba-3182-492a-ab46-23cfa5ec913c%40aklaver.com>
Precedence: bulk

On 7/23/24 13:11, Vincent Veyron wrote:
> 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)?
>>
> 
> 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

Just know that SQLite does not enforce types, therefore it is entirely 
possible that there are values in fields that are not valid in Postgres.

Think:

select ''::integer
ERROR:  invalid input syntax for type integer: ""
LINE 1: select ''::integer


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

-- 
Adrian Klaver
adrian.klaver@aklaver.com