public inbox for [email protected]  
help / color / mirror / Atom feed
Need PostgreSQL Key words list
5+ messages / 4 participants
[nested] [flat]

* Need PostgreSQL Key words list
@ 2018-01-30 08:18 PG Doc comments form <[email protected]>
  2018-01-30 13:08 ` Re: Need PostgreSQL Key words list Bruce Momjian <[email protected]>
  2018-01-30 14:24 ` Re: Need PostgreSQL Key words list Tom Lane <[email protected]>
  0 siblings, 2 replies; 5+ messages in thread

From: PG Doc comments form @ 2018-01-30 08:18 UTC (permalink / raw)
  To: [email protected]; +Cc: [email protected]

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/static/sql-keywords-appendix.html
Description:

Hi,

Some people developing code formatting/highlighting plugins use this table
as the list of PostgreSQL key words:
https://www.postgresql.org/docs/current/static/sql-keywords-appendix.html 

However, that list isn't complete, eg. TIMESTAMPTZ, JSON, UUID... are
missing, probably because these aren't in SQL standard.

Would you please consider having a full list of PostgreSQL Key words, either
in that table, or somewhere else?

Thanks


^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Need PostgreSQL Key words list
  2018-01-30 08:18 Need PostgreSQL Key words list PG Doc comments form <[email protected]>
@ 2018-01-30 13:08 ` Bruce Momjian <[email protected]>
  2018-01-30 14:30   ` Re: Need PostgreSQL Key words list Pavel Luzanov <[email protected]>
  1 sibling, 1 reply; 5+ messages in thread

From: Bruce Momjian @ 2018-01-30 13:08 UTC (permalink / raw)
  To: [email protected]; [email protected]

On Tue, Jan 30, 2018 at 08:18:27AM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/10/static/sql-keywords-appendix.html
> Description:
> 
> Hi,
> 
> Some people developing code formatting/highlighting plugins use this table
> as the list of PostgreSQL key words:
> https://www.postgresql.org/docs/current/static/sql-keywords-appendix.html 
> 
> However, that list isn't complete, eg. TIMESTAMPTZ, JSON, UUID... are
> missing, probably because these aren't in SQL standard.
> 
> Would you please consider having a full list of PostgreSQL Key words, either
> in that table, or somewhere else?

The most current keyworsd list is in our source tree:

	https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/include/parser/kwlist.h;h=26af944e0...

However, that doesn't have TIMESTAMPTZ or JSON because those are data
types, not keywords.

-- 
  Bruce Momjian  <[email protected]>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Need PostgreSQL Key words list
  2018-01-30 08:18 Need PostgreSQL Key words list PG Doc comments form <[email protected]>
  2018-01-30 13:08 ` Re: Need PostgreSQL Key words list Bruce Momjian <[email protected]>
@ 2018-01-30 14:30   ` Pavel Luzanov <[email protected]>
  2018-01-30 14:36     ` Re: Need PostgreSQL Key words list Bruce Momjian <[email protected]>
  0 siblings, 1 reply; 5+ messages in thread

From: Pavel Luzanov @ 2018-01-30 14:30 UTC (permalink / raw)
  To: [email protected]

On 30.01.2018 16:08, Bruce Momjian wrote:
> The most current keyworsd list is in our source tree:
And this list is accessible through the pg_get_keywords() function.

-----
Pavel Luzanov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Need PostgreSQL Key words list
  2018-01-30 08:18 Need PostgreSQL Key words list PG Doc comments form <[email protected]>
  2018-01-30 13:08 ` Re: Need PostgreSQL Key words list Bruce Momjian <[email protected]>
  2018-01-30 14:30   ` Re: Need PostgreSQL Key words list Pavel Luzanov <[email protected]>
@ 2018-01-30 14:36     ` Bruce Momjian <[email protected]>
  0 siblings, 0 replies; 5+ messages in thread

From: Bruce Momjian @ 2018-01-30 14:36 UTC (permalink / raw)
  To: Pavel Luzanov <[email protected]>; +Cc: [email protected]

On Tue, Jan 30, 2018 at 05:30:59PM +0300, Pavel Luzanov wrote:
> On 30.01.2018 16:08, Bruce Momjian wrote:
> 
>     The most current keyworsd list is in our source tree:
> 
> And this list is accessible through the pg_get_keywords() function.

Sorry, yes, I forgot we added that long ago.  Thanks.

-- 
  Bruce Momjian  <[email protected]>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Need PostgreSQL Key words list
  2018-01-30 08:18 Need PostgreSQL Key words list PG Doc comments form <[email protected]>
@ 2018-01-30 14:24 ` Tom Lane <[email protected]>
  1 sibling, 0 replies; 5+ messages in thread

From: Tom Lane @ 2018-01-30 14:24 UTC (permalink / raw)
  To: [email protected]; +Cc: [email protected]

=?utf-8?q?PG_Doc_comments_form?= <[email protected]> writes:
> However, that list isn't complete, eg. TIMESTAMPTZ, JSON, UUID... are
> missing, probably because these aren't in SQL standard.

Those are not key words.  They're just names.

			regards, tom lane




^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2018-01-30 14:36 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-01-30 08:18 Need PostgreSQL Key words list PG Doc comments form <[email protected]>
2018-01-30 13:08 ` Bruce Momjian <[email protected]>
2018-01-30 14:30   ` Pavel Luzanov <[email protected]>
2018-01-30 14:36     ` Bruce Momjian <[email protected]>
2018-01-30 14:24 ` Tom Lane <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox