Re: Problems when using unaccent

2024-01-02 Thread Tom Lane
PG Doc comments form writes: > I'm trying to query a database with unaccent, but PostgreSQL gives me > exceptions: > ERROR: function unaccent(character varying) does not exist at character > 139 It looks like you haven't installed the unaccent extension in that database. See https://www.postg

Problems when using unaccent

2024-01-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/unaccent.html Description: I'm trying to query a database with unaccent, but PostgreSQL gives me exceptions: ERROR: function unaccent(character varying) does not exist at character 139 H

Re: Transition relation clarification

2024-01-02 Thread Dull Bananas
The documentation is not specific enough about what a transition table is or what it means to create a transition table, so I assumed that it works similarly to `CREATE TEMPORARY TABLE`. The existence of variable-like tables is not documented. On Mon, Jan 1, 2024 at 10:22 David G. Johnston wrote: