[Q&A] How can I specify the field name when using the new pdb.match function?

[abdelfattahradwan]

What happens?

I used to be able to specify the field name used for @@@ queries when using the paradedb.match function by supplying a value to the field argument. For example, if I had an index like this:

create index if not exists snippets_bm25_idx on public.snippets using bm25 (id, name, description, content, created_at, modified_at) with (
	key_field = 'id',
	text_fields = $$
		{
			"name_ngram": {
				"column": "name",
				"tokenizer": {
					"type": "ngram",
					"min_gram": 2,
					"max_gram": 3,
					"prefix_only": false
				}
			},
			"description_default": {
				"column": "description",
				"tokenizer": {
					"type": "default"
				}
			},
			"content_source_code": {
				"column": "content",
				"tokenizer": {
					"type": "source_code"
				}
			}
		}
	$$
);

I used to be able to do this:

select
	public.snippets.id,
	public.snippets.name
from
	public.snippets
where
	public.snippets.id @@@ paradedb.match(
		field := 'name_ngram',
		value := 'sample query'
	)
order by
	paradedb.score(public.snippets.id) desc,
	public.snippets.modified_at desc
limit
	10;

So, can I do the same when using pdb.match? I searched the docs but couldn't find something that helps (or maybe I missed it?)

To Reproduce

N/A

OS:

Debian GNU/Linux 12 (bookworm)

ParadeDB Version (e.g. output of SELECT * FROM paradedb.version_info();):

0.18.0

Are you using ParadeDB Docker, Helm, or the extension standalone?

ParadeDB pg_search Extension

Full Name:

Abdelfattah Radwan

Affiliation:

KZ Development

Did you include all relevant data sets for reproducing the issue?

N/A - The reproduction does not require a data set

Did you include the code required to reproduce the issue?

• Yes, I have

Did you include all relevant configurations (e.g., CPU architecture, PostgreSQL version, Linux distribution) to reproduce the issue?

• Yes, I have

[abdelfattahradwan]

According to this, there is no way to supply a field name to the new pdb.* functions, so I will stick with the paradedb.* ones.

[philippemnoel]

Hi @abdelfattahradwan. The v2 of the API is in "beta" mode right now and is not fully ready! Thank you for trying it out. We'll let you know once it is feature-parity with the existing API.