Re: Ambiguity in VALUES synopsis: LIMIT vs FETCH

2025-08-27 Thread David G. Johnston
On Tuesday, August 26, 2025, Cheng Ding wrote: > Hello docs team, > > I believe there’s an ambiguity in the VALUES command synopsis that can > mislead readers into thinking LIMIT and FETCH can be used together. > > *…* > > Alternatively, add a short note right under the synopsis: > > Note: FETCH

Ambiguity in VALUES synopsis: LIMIT vs FETCH

2025-08-27 Thread Cheng Ding
Hello docs team, I believe there’s an ambiguity in the VALUES command synopsis that can mislead readers into thinking LIMIT and FETCH can be used together. *What I ran* VALUES (12, 'nectarine') LIMIT 1 FETCH FIRST 1 ROW ONLY; *What happened* ERROR: syntax error at or near "FETCH" *Why I thin