unquoted special constants

Started by Christopher Kings-Lynnealmost 23 years ago3 messages

Christopher Kings-Lynne

chriskl@familyhealth.com.au

almost 23 years ago

Hi,

Is this the complete list of constants that must not be quoted?

CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_DATE
LOCAL_TIME
LOCAL_TIMESTAMP
CURRENT_USER
SESSION_USER
USER

Anything else? (Aside from functions?)

Chris

Bruce Momjian

pgman@candle.pha.pa.us

almost 23 years ago

In reply to: Christopher Kings-Lynne (#1)

Re: unquoted special constants

Looks like you got them all. I assume you got those from gram.y.

---------------------------------------------------------------------------

Christopher Kings-Lynne wrote:

Hi,

Is this the complete list of constants that must not be quoted?

CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_DATE
LOCAL_TIME
LOCAL_TIMESTAMP
CURRENT_USER
SESSION_USER
USER

Anything else? (Aside from functions?)

Chris

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Christopher Kings-Lynne

chriskl@familyhealth.com.au

almost 23 years ago

In reply to: Bruce Momjian (#2)

Re: unquoted special constants

No actually, the docs.

I need to know for the phpPgAdmin project...

Chris

Show quoted text

-----Original Message-----
From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
Sent: Sunday, 26 January 2003 10:03 AM
To: Christopher Kings-Lynne
Cc: Hackers
Subject: Re: [HACKERS] unquoted special constants

Looks like you got them all. I assume you got those from gram.y.

------------------------------------------------------------------
---------

Christopher Kings-Lynne wrote:

Hi,

Is this the complete list of constants that must not be quoted?

CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_DATE
LOCAL_TIME
LOCAL_TIMESTAMP
CURRENT_USER
SESSION_USER
USER

Anything else? (Aside from functions?)

Chris

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
Bruce Momjian                        |  http://candle.pha.pa.us
pgman@candle.pha.pa.us               |  (610) 359-1001
+  If your life is a hard drive,     |  13 Roberts Road
+  Christ can be your backup.        |  Newtown Square,
Pennsylvania 19073