Re: ODBC options

2023-10-09 Thread Brad White
On Fri, Oct 6, 2023 at 2:30 PM Bruce Momjian wrote: > On Tue, Oct 3, 2023 at 05:34:01PM -0500, Brad White wrote: > > I was trying to figure how to set the log directory on my Windows > client > > using a parameter in the connection string. Short answer is that you > can't. > > But you can usin

Re: Typo in PL/pgSQL trigger Example 43.4?

2023-10-09 Thread Tom Lane
Daniel Gustafsson writes: >> On 7 Oct 2023, at 22:22, Tom Lane wrote: >> Yeah, either way has the same result. However, I wonder if we should >> change this example to use current_user for clarity. It does look >> more like it's intended to be a variable or column reference than >> a built-in f

Re: Example numeric constants aren't valid?

2023-10-09 Thread Tim Needham
Oh goodness, sorry Vik. On Mon, Oct 9, 2023 at 11:37 AM Vik Fearing wrote: > On 10/6/23 20:49, PG Doc comments form wrote: > > > > I'm left not really understanding how to use _ in numerical constants? > > You are reading the documentation for 16, but you are using 14 or lower. > If you want

Re: Example numeric constants aren't valid?

2023-10-09 Thread Vik Fearing
On 10/6/23 20:49, PG Doc comments form wrote: > I'm left not really understanding how to use _ in numerical constants? You are reading the documentation for 16, but you are using 14 or lower. If you want this functionality, you need to upgrade your server. -- Vik Fearing

Example numeric constants aren't valid?

2023-10-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-syntax-lexical.html Description: Hi, Re. Docs page: https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS-NUMERIC I noticed that the following are spec

Re: Typo in PL/pgSQL trigger Example 43.4?

2023-10-09 Thread Daniel Gustafsson
> On 7 Oct 2023, at 22:22, Tom Lane wrote: > > "David G. Johnston" writes: >> On Sat, Oct 7, 2023 at 11:11 AM Kirk Parker wrote: >>> INSERT INTO emp_audit SELECT 'D', now(), user, OLD.*; -- <= ARGUMENT IN >>> QUESTION >>> The emp_audit table has a column named 'userid', which in actual usage >