Composite type field reference in sqlc generated query for golang
I have a simple postgres sql query with a WHERE clause that references a field of a composite type.
SQLC generate: ‘relation “users” does not exist’
I have a directory of migrations.
One of those migration files has the name of 20240718160024_initial_tables.sql
This migration file contains the sql to create the users table.
When I run sqlc generate
i get the following error.
Getting Empty Records Back Using Golang, SQLC and PostgreSQL
I am trying to implement pagination in my GO backend API. The API uses SQLC
for the abstraction through to my PostgreSQL database. The issue is, It returns blank records and i cannot figure out what am doing wrong. The following are relevant codes pertaining to my current work:
Creation of a new Query object instead of using the already exitsting one
Am learning about implementing DB transactions in golang and for that, the instructor was creating a query object which will be having access to all the CRUD methods. But he also have a object which is having the Query as a data member in the struct. Why cant we use that?