Unable to read json range into pgtype.Int4range
php editor Baicao may encounter an error message when using PHP and PostgreSQL database: "Unable to read json range as pgtype.Int4range". This error usually occurs when trying to convert the JSON data type to the pgtype.Int4range data type. The solution to this problem is not complicated. You only need to convert the JSON data to a string and then perform data type conversion. Next, we will detail how to solve this problem.
Question content
I'm trying to read a range into json but I'm having trouble doing json.unmarshal.
This is a test code-
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
|
mistake-
1 |
|
Is it possible to read it as pgtype.int4range? I guess this type is for database use only? fwiw, I'm using pgx github.com/jackc/pgx/v4
Workaround
It doesn't work because "[20,30)"
is not a struct A valid json value for pgtype.int4range
, and pgtype.int4range does not yet implement the json.unmarshaler interface.
You must implement the interface to unmarshal yourself "[20,30)"
:
1 2 3 4 5 |
|
by the way
1 |
|
Comparing two different types, should be corrected to:
1 |
|
View the full demo here: https://www.php.cn/link/fbf6e9ffad68f73e466198206987dedc一个>.
The above is the detailed content of Unable to read json range into pgtype.Int4range. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

This article explains Go's package import mechanisms: named imports (e.g., import "fmt") and blank imports (e.g., import _ "fmt"). Named imports make package contents accessible, while blank imports only execute t

This article explains Beego's NewFlash() function for inter-page data transfer in web applications. It focuses on using NewFlash() to display temporary messages (success, error, warning) between controllers, leveraging the session mechanism. Limita

This article details efficient conversion of MySQL query results into Go struct slices. It emphasizes using database/sql's Scan method for optimal performance, avoiding manual parsing. Best practices for struct field mapping using db tags and robus

This article demonstrates creating mocks and stubs in Go for unit testing. It emphasizes using interfaces, provides examples of mock implementations, and discusses best practices like keeping mocks focused and using assertion libraries. The articl

This article explores Go's custom type constraints for generics. It details how interfaces define minimum type requirements for generic functions, improving type safety and code reusability. The article also discusses limitations and best practices

This article details efficient file writing in Go, comparing os.WriteFile (suitable for small files) with os.OpenFile and buffered writes (optimal for large files). It emphasizes robust error handling, using defer, and checking for specific errors.

The article discusses writing unit tests in Go, covering best practices, mocking techniques, and tools for efficient test management.

This article explores using tracing tools to analyze Go application execution flow. It discusses manual and automatic instrumentation techniques, comparing tools like Jaeger, Zipkin, and OpenTelemetry, and highlighting effective data visualization
